How I can show table or message?

[Denis_Slav]

Hi All, 

I need to show table, if slicer get one record, otherwise show text message. How i can do that? 

[v-henryk-mstf · Accepted solution]

Hi @Denis_Slav ,

According to your description, whether your requirement is: When the slicer is not selected, the value similar to the text is displayed. When the specific slicer is selected, the result of the corresponding table is displayed?

Here is a blog that can be used as a reference like below and may be able to meet your needs.Show or Hide a Power BI Visual Based on Selection - Excelerator BI

Let me know the result immediately, looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PhilipTreacy]

Hi @Denis_Slav 

This isn't seomthgn that's built in to PBI as a default.  You can't 'hide' a visual.  You could though display nothing in it.  So if a slicer has selected a particular value, your card could display an empty string ""

With a table it's a bit more complicated.  You could set conditional formatting so that the font of the values in the table match the background - hence making them 'disappear' .  But you can't do th same with the Table Headers.

Maybe of you provide an example of exactly what you are trying to achieve I can help more.

Regards

Phil

[Denis_Slav]

@PhilipTreacy Thank you. I saw one of the way to use conditional formating and i'm going to try that. 

Main aim, to show details about exact incident.