Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Hide Visual

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

Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    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.

5 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    5 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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's avatar
        Greg_Deckler
        Community Champion
        5 years ago

        Anonymous I believe:

        New Measure = IF(HASONEVALUE('Table'[Account]),[Old Measure],BLANK())
  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

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

     

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    5 years ago

    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.