Forum Discussion
Use aggregated data in slicer
Hi everyone,
I would like to show aggregated data in a slicer, based on the dates, selected in another one.
This is an a example of campaign data, I would like to analyze:
In my report, I would like to identify the campaigns, which cause cost but don't lead to transactions. Further, I would like to filter the table, so it only shows the campaigns with a mimimum of cost in the selected time period. As you can see below, the "cost" slicer only shows the raw data. I want it to show in this case a min. of 25 € and a max. of 55 €.
Unfortunately, I can't use a measure as slicer. Is there any other way to filter it?
(I know that I could filter in the table settings. But I would like to use a slicer, because it's more flexible and can be adjusted by any user who views this report.)
Thank you very much in advance!
With best regards, Diana
As an alternative, you may use RANKX Function to add a measure and take advantage of Visual level filters.
Measure = RANKX ( ALLSELECTED ( Table1[Campaign] ), CALCULATE ( SUM ( Table1[Cost] ) ), , ASC, DENSE )
3 Replies
As an alternative, you may use RANKX Function to add a measure and take advantage of Visual level filters.
Measure = RANKX ( ALLSELECTED ( Table1[Campaign] ), CALCULATE ( SUM ( Table1[Cost] ) ), , ASC, DENSE )Hi v-chuncz-msft,
thanks for your help! I created a list of data to select and use this one as slicer. However it would be create to be able to use dynamic values. I hope that It will be possible to use a meassure as slicer in the future, because it would be much more flexible.
To help improve Power BI, you may give feedback via https://ideas.powerbi.com/forums/265200-power-bi.
