Forum Discussion
Using a measure as a slicer
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, 1...
Hi,
- Create a disconnected table with your groups (see figure 1).
- Create a measure with SWITCH() (figure 2).
- Create the slicer (figure 3).
- Use the SWITCH() measure insice your visual.
Figure 1: Disconnected table
Figure 2: SWITCH()
Figure 3: Slicer
Regards Frank AT