Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi everyone,
I want to show the available values in the slicer which has some values in fact.
I have one dimension table and one fact table. Relation is one to many. As you can see category D has no values. In the text box below I want to shows only those category which has some values.
This is the measure that i am using:
Solved! Go to Solution.
@TaroGulati , using value measure
CALCULATE(CONCATENATEX ( filter(VALUES(Dim[Category1]), not(isblank([Value])) ), Dim[Category1],", "))
@TaroGulati , using value measure
CALCULATE(CONCATENATEX ( filter(VALUES(Dim[Category1]), not(isblank([Value])) ), Dim[Category1],", "))
User | Count |
---|---|
120 | |
65 | |
62 | |
56 | |
50 |
User | Count |
---|---|
181 | |
85 | |
69 | |
62 | |
55 |