cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
stevedep
Super User I
Super User I

Sharing: Use Dynamic SVG for Debugging or Teaching DAX.

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

 

stevedep_0-1613807312007.png

 

4 REPLIES 4
lbendlin
Super User III
Super User III

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!

lbendlin
Super User III
Super User III

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  

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors