Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to display or hide a visual conditionally?

I have created two table visuals for Domestic Sales and Export Sales respectively on one page having drill through for sales.  A sales person can have either domestic sales, export sales or both.  So if any sales person have sales only in one category then one table visual will be blank and I want to hide it if it does not contain any rows.

Need Help

4 Replies

  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Hi Anonymous 

    You might be able to get there with bookmarks. Can you share the pbix  (one with dummy data if necessary) and explain on it exactly what visual you want to hide and when?

     

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you all -@AlB, amitchandak and Lionel Chen for your replies.  I am unable to produce more info for this as my power bi report hangs immediately after opening.  So based on my earlier backup copy of the report, I have solved this problem by combining both domestic sales and export sales tables using union into one table and displayed order details into one table visual. 

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

    Hi Anonymous ,

     

    Is it like this?

     

    You just need to create such a measure and add the measure to the 'Filters on this visual' pane.

    Filter = 
IF(
    SUM('Export Sales'[Export Sales]) = 0,
    1,0
)

     

    If not, please give sample data and detailed instructions.

     

    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.