Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I am writing this to share an idea to debug/explain the inner working of DAX code to others. The DAX code generates SVG code that allows us to highlight certain rows. Perhaps these are rows we like to work with when an inner DAX statement is at work.
Hopefully, the below code is self-explanatory. Please mind that you need to change the 'Data Category' of the measure to 'Image URL'. I suggest changing the 'Image height' as well (see highlight in below image). The file is attached.
Any (creative) suggestions for improvements or other use cases are welcome.
Credits to @matemusic for the inspiration.
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
The height is not a problem. You can use the HTML5 visual.
What I am looking for is the entire table contents, column headers and all rows, as a SVG image.
ah ok, got it!
Great tip, just use an HTML custom visual. Did not think of this. Learning every day! Thanks!
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
Here's a challenge for you. Write a piece of SVG that can return the entire contents of a table variable that is used when building a measure.
Its currently iterating a table variable. If you are hinting towards the image cell height limitation, I created an idea to ask to have this height increased so a larger number of rows can be printed (with colours). Please vote for the idea if you like it:
https://ideas.powerbi.com/ideas/idea/?ideaid=4a172cc5-5073-eb11-8ced-0003ff4569ae
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
User | Count |
---|---|
41 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |