Overview:
Power BI report utilizing Python for dynamically creating custom SVG images in Power BI based on user's selections.
Features/Analysis Enablement:
The report layout has the dynamic SVG image on bottom right. The left (dark blue) section enables toggling visibility for all objects as well as controlling 1 specific object for additional settings by clicking the arrow to right of object row. The middle (light blue) section is for controlling properties for the object selected from before (which gets highlighted in the Objects list) and controls shape, color, size, x-position, and y-position properties. The upper right section has property filters pertaining to the SVG background color/ and axis labels. Technically - this report utilizes Power BI bookmarks/buttons for handling the left dark blue and middle light blue section's interaction logic. The user input is gathered through Power BI Measures/Slicers which get passed to Python visual/Script Editor for creating a SVG within Python using svgwrite module based on this user input, then converting file type within memory to PNG using cairosvg module and ultimately displayed using matplotlib.pyplot visual which can't work with SVGs by default.
Watch this few minute report overview video.
Copyright © 2024 Geoffrey's Data Analysis/Engineering Portfolio - All Rights Reserved.
Powered by GoDaddy
We use cookies to analyze website traffic and optimize your website experience. By accepting our use of cookies, your data will be aggregated with all other user data.