How to add Measure Values To Slicer in Power BI to Slice and Dice your report? Can this be done?

This video will show you how to overcome Power BI limitation which prevents us from dragging measures into a slicer.

With a bit of creativity and work around, we can add measure values to Slicer in Power BI.
This video will show you the secrets step by step, so that you can display measures values in your slicer and use it to slice and dice your report.

Hope you find this video useful.

Cheers,
Isabella Susilowati
@LighthouseAnalytix, #powerbiforbeginners, #powerbi , #powerbitutorialforbeginners

Timelines:
00:00 Intro
02:31 Step 1: Create your Measure Classification
03:16 Step 2: Create an independent Filter classification Table
04:32 Step 3 : Add "Selection" field to our slicer
05:14 Step 4 : Create a Filter Flag Measure using Switch
06:55 Step 5 : Add the Filter Flag to your visuals
08:03 Epilogue

License code: O511QTCIB3JAADFA

LA132

[dnr]

Thanks Isabella, I used your method for a dashboard and worked very well. Thank you so much for sharing your expert knowledge :)

[workstuff]

A great way to start my week, with a great tip - delivered by you with brightness and happiness.

[lucassudo]

that`s exatcly what i needed. thank you for sharing

[shubhabratadey]

Awesome trick. Many thanks for this video

[lucasrezende]

Thank you for that! Really helped here!

[thatgoanguy]

Wow. This worked. Thank you very much❤

[ooizenming]

thank you, really help alot, calculated column have lead me to different value. This video save my time at least for few hour

[tomerweil]

Awsome, I just integrated into my project controlling dashboard, to filter project that are "On-Time" and "Delay". Thanks a lot!

[Orlandolover]

thank you so much, i hate circular dependency and this just saved me from having to spend another 2 hours dealing with circular dependency.

[ronaldpum]

Love your videos, especially the PowerBi. I am based in Adelaide and my employer is looking for a new CFO, it would be a dream to have someone like you onboard 🤩

[mohammadghafaripour]

How about if the data comes from SSAS model and we dont want to add a table to our model?

[thejavshow]

Is there a way to do something similar but with multi-select rather than single select?

[jorgeandresrodriguez]

this activity function in kpis? or not

[dstorm]

Is it possible to slice based on an aggregate value from the original measure rather than having to create new categories through a new measure? i.e. Slicer that lets u filter the range of 'Diff_Amount'. So example, > 0$ but <1000$

[viethama]

How can i set measure slicer with multiple selection

[praneethvarma]

If measure returns a percentage value and can we use that measure in slicer?
Tried multiple ways and if your answer is yes please make a video

Thanks in advance

[dream_merchant_]

Can you drop resource files in the comment? So we can learn by doing.

[megaherz]

Interesting, all of this to avoid using a calculated column.

[walterstevens]

It seems an incredibly long winded approach to what is a simple requirement...