Use aggregated data in slicer

[DianaG]

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

[v-chuncz-msft · Accepted solution]

@DianaG,

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
)

[DianaG]

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.

[v-chuncz-msft]

@DianaG,

To help improve Power BI, you may give feedback via https://ideas.powerbi.com/forums/265200-power-bi.