Hide Visual

[Anonymous]

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

[v-lionel-msft · Accepted 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.

[amitchandak]

@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())

[Greg_Deckler]

@Anonymous - Sorry, having trouble following, not sure you can hide the entire visual without using a Bookmark ?

[Anonymous]

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

[Greg_Deckler]

@Anonymous I believe:

New Measure = IF(HASONEVALUE('Table'[Account]),[Old Measure],BLANK())