Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Experts
I have a filter in the following format in a table in Power BI
Name Index
AOP 1
PY 2
i issues i am having is that when a user does not select either AOP and or PY the filter shows ALL - how do you stop this so that user only has the option of AOP,PY and not ALL..
Solved! Go to Solution.
@Anonymous,
Drag measure below to Visual level filters and set Show items when the value is not blank.
Measure = CALCULATE ( SELECTEDVALUE ( Table1[Name] ), ALLSELECTED ( Table1[Name] ) )
@Anonymous,
Drag measure below to Visual level filters and set Show items when the value is not blank.
Measure = CALCULATE ( SELECTEDVALUE ( Table1[Name] ), ALLSELECTED ( Table1[Name] ) )
Hi @Anonymous
Maybe you can use ISFILTERED(Table1[Name]) to test whether the user has made any selection (FALSE if they haven't)
With that you can take the necessary steps in your measure
AIB, let me think about that point and come back to you with the formula and or a screen shot of the problem to had.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |