Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello,
From the picture above, you can see that I have used 4 slicers to calculate different things i.e.e hours, billing amount and total amount.
If I do not select anything, it shows this value (refer to the picture above). These values are accumulated and mean absolutely nothing, they only mislead the user. Please if someone can tell me what to do? Is there any way/option I can use where my table shows blank or nothing if nothing is selected from the slicer? Thanks.
P.S New to Power BI, not that good with DAX.
Solved! Go to Solution.
Hi @Anonymous ,
Please set a new measure:
Please new a measure:
Measure1 = CALCULATE ( IF ( ISFILTERED ( Table[Column] ), 1, 0 ), ALLSELECTED ( Table ) )
Add this measure to visual level filters, and set its value to 1.
Regards,
Daniel He
What you can do with the new feature of Field Parameters (check in Preview features):
In my case it works.
Measure1 =
CALCULATE ( IF ( ISFILTERED ( Table[Column] ), SELECTEDVALUE(Table1[Column1] ), "" ))
Hi @Anonymous ,
Please set a new measure:
Please new a measure:
Measure1 = CALCULATE ( IF ( ISFILTERED ( Table[Column] ), 1, 0 ), ALLSELECTED ( Table ) )
Add this measure to visual level filters, and set its value to 1.
Regards,
Daniel He
Hi there,
I have attempted to use this solution and succesfully created the measure. I have checked it using a card and it returns a value of zero when nothing is selected on my slicer and a value of 1 when something is selected. However, when I place it as a fliter for a visual, it does not let me set the vlaue to 1. It looks as shown in the picture and does nothing when I click the dropdown arrow to try to select "is" and then set the value to 1. Any suggestions?
Thanks
LilMurph
There must have been some fundamental change since this original post because I don't believe you can use a measure as a filter.
same issue here, hope anyone found a solution?
I have the same problem, did you manage to find a solution?
Thank you Daniel.😊
I had the same problem here
Hi,
This works for me but if I "Select All", I get a blank again. Why is that?
@Anonymous
You can try using the function hasonefilter with your slicers so if your slicers have a filter then do the calculations, otherwise return blank().
https://docs.microsoft.com/en-us/dax/hasonefilter-function-dax
something roughly like
TotalHours = if(hasonefilter(ClientDescription[name]),Sum(TotalHours),Blank())
Nopes, does not work. Basically, if I do not select anything from the slicer, my table should show blank but it does not. As you can see from the picture, it shows an accumulated value of something. I do not need that value if I have not selected anything!
My slicers are interlinked with each other (if that helps), for example if you choose an individual's name, the other slicers would show the parts that are only associated with the individual.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
86 | |
82 | |
70 | |
49 |
User | Count |
---|---|
143 | |
123 | |
107 | |
61 | |
55 |