Hide table chart when no filter is selected from Slicers and display message

[Anonymous]

Hello All,

I have 3 slicers Entity, Halfyearly, Year 
I need to show data in table only all the three filters are selected and initially it should show blank page with 3 slicers not selecting anything or display message like select Entity, HalfYearly and Year to view data
Also, If I have 2 records in entity. If I select first value and other 2 slicers values it will display data accirding to first entity in table chart vice versa for second entity

I used below measures for that

Filter To Show Raw Data table = ISFILTERED(Responses[Entity])

                                && ISFILTERED(Responses[HalfYearly]) && ISFILTERED(Responses[Year])

Hide Row Data table =

   IF(

      [Filter To Show Raw Data table],

      1, //True

      0 //False

   )

I added Hide Raw data table measure in Filters of this visual for table chart and selected 1, so it given data according to selection

But when Nothing is selected it's showing no data but columns are visible. I want to display message when nothing is selected .
How to achieve it 

Please Help 🙂

Thanks in advance!

[Anonymous]

Hi @Anonymous ,

Based on the description, try to use two tables.

Drag the table column to the three slicers and drag another table column to the table visual.

Measure = 
var _enti = SELECTEDVALUE('table'[Entity])
RETURN
IF(ISFILTERED('table') && _enti = SELECTEDVALUE('Table (2)'[Entity]), 1, 0)

Best Regards,

Wisdom Wu

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

[rajendraongole1]

Hi @Anonymous - you can add a measure that displays a custom message when no slicer selections as below:

Display Message =
IF(
NOT(ISFILTERED(Responses[Entity]))
|| NOT(ISFILTERED(Responses[HalfYearly]))
|| NOT(ISFILTERED(Responses[Year])),
"Select Entity, HalfYearly, and Year to view data.",
BLANK()
)

now, Insert a Card Visual on your page.Set its value to the Display Message measure.Format the card to prominently display the message, such as centering it and using a large font size.

In setting filters add the below conditions
Set the card visual to display when Hide Raw Data table = 0.
Set the table visual to display when Hide Raw Data table = 1.

it works.

[Anonymous]

Hi @rajendraongole1 

I cannot change Hide row data to 0, I cannoyt able to select anything from dropdown, it's not drop dowining