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.
Hello All,
I have the Below Visualization, which is based on Direct Query.
The data is based on Slicer. If I select multivalues in the Slicer the Visualization should be Hidden else it should display.
Since the Storage Mode is Direct Query, I cannot change the data type 'Date'[TODAY] from text to Number in M/DAX to use in the below Measure.
Measure = IF(COUNTROWS ( FILTERS ( ZZ[Account] ) ) > 1, BLANK(), 'Date'[TODAY] ) --> Not allowing
Any one has any thoughts on to include 'Date'[TODAY] in the new Measure or any other way I can acheive this scenario.
Regards
Chandra
Solved! Go to Solution.
Hi @Anonymous ,
You can create a measure and add it to the filter on the visual.
__Filter =
VAR x =
COUNTAX(
ALLSELECTED(Sale),
[Customer_ID]
)
RETURN
IF(
x = 1,
1, 0
)
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
You can create a measure and add it to the filter on the visual.
__Filter =
VAR x =
COUNTAX(
ALLSELECTED(Sale),
[Customer_ID]
)
RETURN
IF(
x = 1,
1, 0
)
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous ,Based on what I got
Hide visualization means you are making content blank. Because the other option is the bookmark button. I doubt that will help in this case,
The date should have date datatype. Not sure why text. You should able to change the data type in column tools for most of the databases in direct query.
The date is DD-MM-YYYY format that needs a setting to work as date. Hope that is in place.
try Something like this
measure =
var _sel = countroes(allselected(Table[field]))
return
if(_sel >2, [measure], blank())
@Anonymous - Sorry, having trouble following, not sure you can hide the entire visual without using a Bookmark ?
Hi @Greg_Deckler ,
Apologies for the confusion.
I have a Slicer, filters on Account. If I select one Account, the Visual should Display but if Selected MultiValue in Slicer the Visual should Hide. Im trying to Acheive this requirement, unfortunately Im not able to do.
Regards
Chandra
@Anonymous I believe:
New Measure = IF(HASONEVALUE('Table'[Account]),[Old Measure],BLANK())
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 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |