Using a measure as a slicer

[cartercambest]

Hey All,

I am attemtping to use a measure on a slicer using a live connection data set.

The slicer I am attemtping to make would have three categories for Total Charges. 0 - 300, 301 - 999, 1000 +.

Please let me know if you have any suggestions.

Thank you,

[Anonymous]

@cartercambest 

Generally, a measure can't be used to create slicer directly. There are some workarounds, you can find them in the forum:

https://community.powerbi.com/t5/forums/searchpage/tab/message?filter=location&q=use%20measure%20sli...

However, since you are using live connection datasource. I am afraid current it is not possbile to meet your requirements.

Best, Regards

Paul Zheng

[Greg_Deckler]

@cartercambest as @FrankAT mentioned, in general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick...

However, since you are using a Live Connected dataset you can't do this. Is this Live or DirectQuery? Any chance you can switch to composite to add in the extra table you need?

[FrankAT]

Hi,

1. Create a disconnected table with your groups (see figure 1).
2. Create a measure with SWITCH() (figure 2).
3. Create the slicer (figure 3).
4. Use the SWITCH() measure insice your visual.

Figure 1: Disconnected table

Figure 2: SWITCH()

Figure 3: Slicer

Regards Frank AT