Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
wynhodgkiss
Helper III
Helper III

Measure Names Dimension

Hi,

Anyone that has used Tableau will understand the concepts of Measure Names as a Dimension and Measure Values as a Measure, making it much easier to present multiple measures in either tabular or visual form. My question is whether there is a way to create the same thing in Power BI.

In my example I have 6 measure for the same product that could be presented in a single line chart (with 6 meaures on the y axis) but I'd like to see them as small multiples.

1: Is there any way of creating a field that can be used as my dimension by which to split the single chart into small multiples?

2: Bonus points if it can be turned into a function to use in future reports with any necessary tweaks

 

PS. I know that I can create a new table with all 6 measures in 1 column, I am just hoping there is a more elegant, quicker way of achieving the same.

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@wynhodgkiss , In power bi we can not use the measure as dimension by mentioning a level(group by) , you need to create dynamic  segmentation

 

range based

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...


Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

 

Absolute value

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

 

values based

Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://www.youtube.com/watch?v=W4EF1f_k6iY

 

View solution in original post

2 REPLIES 2
wynhodgkiss
Helper III
Helper III

Thanks @amitchandak , this looks like it will do the trick. 

amitchandak
Super User
Super User

@wynhodgkiss , In power bi we can not use the measure as dimension by mentioning a level(group by) , you need to create dynamic  segmentation

 

range based

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...


Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

 

Absolute value

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

 

values based

Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://www.youtube.com/watch?v=W4EF1f_k6iY

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.