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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
elguestca1
Frequent Visitor

Dynamic measures in chart

Hello,

is there a way to lets say make a chart by date with several measures, but only one at a time. Like I chose to see sum by date, I see sum by date, I choose to see count by date, I see count by date.  I mean like using a slicer with measures. I know about parameter, but since I am connecting to Power BI Dataset, I can not create columns or use parameter. Maybe it is possible to do it somehow with buttons? Or maybe there is other way to do it? 

Thank you.

1 ACCEPTED SOLUTION
Dhairya
Solution Supplier
Solution Supplier

Hey @elguestca1 
If you are not able to use the field parameter (which is the best possible way) you have a workaround of using Bookmarks.

you have to create seperate bookmarks for all individual calculations you want to display at a time and you have to create same number of button as number bookmarks and set respective action.

for example

bookmark 1 (sum by date)
visual - sum by date (show) & count by date(hide)

bookmark 2 (count by date)
visual - count by date(show) & sum by date (hide)

button 1 (for sum by date)
action:  navigate to bookmark 1 (sum by date)

button 2 (for count by date)
action:  navigate to bookmark 2 (count by date)


If this helps you then please mark my solution as accepted so that others can find it quickly when they face similar issue. Thank You!

View solution in original post

2 REPLIES 2
Dhairya
Solution Supplier
Solution Supplier

Hey @elguestca1 
If you are not able to use the field parameter (which is the best possible way) you have a workaround of using Bookmarks.

you have to create seperate bookmarks for all individual calculations you want to display at a time and you have to create same number of button as number bookmarks and set respective action.

for example

bookmark 1 (sum by date)
visual - sum by date (show) & count by date(hide)

bookmark 2 (count by date)
visual - count by date(show) & sum by date (hide)

button 1 (for sum by date)
action:  navigate to bookmark 1 (sum by date)

button 2 (for count by date)
action:  navigate to bookmark 2 (count by date)


If this helps you then please mark my solution as accepted so that others can find it quickly when they face similar issue. Thank You!

Hello, @Dhairya,

Great workaround. Thank you very much!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

April Fabric Community Update

Fabric Community Update - April 2024

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

March 2024 PBI Gallery Image

Power BI Monthly Update - March 2024

Check out the March 2024 Power BI update to learn about new features.