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
Tim_Scheepers
Frequent Visitor

Calculation item in slicer

I have multiple calculation items in one calculation group like; MTD, PMTD, YTD, PYTD, CM, LM But in my report i want to show them as groups using a slicer, so for example i only want to show MTD and PMTD but this under 1 button in the slicer, like:

"MTD VS PMTD" is one button in the slicer that shows calculation items MTD an PMTD in my matrix,
"YTD VS PYTD" //,
"CM VS LM" //.

But i don't know how to group calculation items like this in tabular edidtor?

1 ACCEPTED SOLUTION
v-yohua-msft
Community Support
Community Support

Hi, @Tim_Scheepers 

 

Currently, the slicer feature of DAX and Power BI does not directly support creating a button in a slicer to represent multiple computed items. But there are other ways you can try to simulate this effect.

Create a new calculation in your calculation group, such as "MTD VS PMTD", and the DAX expression of this calculation can be a combination of the results of MTD and PMTD.

Or you can use the bookmarks feature to create multiple bookmarks, each representing a view of a set of calculated items. Then when you select a different calculated item in the slicer, use the bookmark to switch views.

Write a DAX Measure to write one or more DAXs that dynamically return the values of calculated items based on the selections in the slicer, and then use those measures in the visual instead of directly using the calculated items in the calculated group.

Of course, you can vote or create your ideas in the following places: Home (microsoft.com)

 

 

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data)

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yohua-msft
Community Support
Community Support

Hi, @Tim_Scheepers 

 

Currently, the slicer feature of DAX and Power BI does not directly support creating a button in a slicer to represent multiple computed items. But there are other ways you can try to simulate this effect.

Create a new calculation in your calculation group, such as "MTD VS PMTD", and the DAX expression of this calculation can be a combination of the results of MTD and PMTD.

Or you can use the bookmarks feature to create multiple bookmarks, each representing a view of a set of calculated items. Then when you select a different calculated item in the slicer, use the bookmark to switch views.

Write a DAX Measure to write one or more DAXs that dynamically return the values of calculated items based on the selections in the slicer, and then use those measures in the visual instead of directly using the calculated items in the calculated group.

Of course, you can vote or create your ideas in the following places: Home (microsoft.com)

 

 

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data)

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Ritaf1983
Super User
Super User

Hi @Tim_Scheepers 
If I understand you correctly you can achieve the desired goal with :
1. calculated groups :
https://www.youtube.com/watch?v=vAnb3e1NCjM

2. dynamic measures :

https://www.youtube.com/watch?v=-o8SIIMJXJ8

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

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

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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