Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi, all please help me, how to write Dax for this situation,
I have 4 slicers created from field parameter
Currently, when I did not select anything from that slicer it shows all data, I really want it to display nothing,
For example, if I select slicer1,3,4 but slicer 2not select
the graph should show data from slicers 1,3,4
thank you in advance
Best Regard
firstch
@firstch , Create a meausre like
Int(calculate(isfiltered(Table[Column1]), allselected()) )
or
Int(calculate(isfiltered(Table[Column1]) || isfiltered(Table[Column2]), allselected()) )
add other columns, change Or || with And &&, if needed
Then use the above measure in visual level filter and filter for value =1
Hi @amitchandak
It doesn't work, i filter only slicer 1 but data from slicer 2,3,4 still show. is there another solution?
Best Regard
firstch
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
22 | |
7 | |
6 | |
6 | |
6 |
User | Count |
---|---|
27 | |
10 | |
10 | |
9 | |
6 |