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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Anonymous
Not applicable

Rolling Up Dynamic Data

 

Hello, I need to use custom measures to make the chart on the left appear as the chart on the right. The data has to be dynamic. How can I go about rolling this up? Thanks

 

 

 

jaguinaga_0-1635971725146.png

 

1 ACCEPTED SOLUTION
PhilipTreacy
Super User
Super User

HI @Anonymous 

 

Download sample PBIX file

 

You need to have a category for each item in order to do this.  No need to write measures.

 

cat1.png

 

The data can then be summarized in a table like this

 

cat2.png

 

 

Regards

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

1 REPLY 1
PhilipTreacy
Super User
Super User

HI @Anonymous 

 

Download sample PBIX file

 

You need to have a category for each item in order to do this.  No need to write measures.

 

cat1.png

 

The data can then be summarized in a table like this

 

cat2.png

 

 

Regards

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors