Table appears only if condition satisfies

[Anonymous]

Hey,

I am creating a table in power bi. I have multiple tables and will show them one by one on the same page through bookmarks and selection pane.

There is one tab called datatable that will contain the dataset in a table form. However, that table can be viewed by a user only if the choose a particular month year from a slicer called month year. So I need like a warning to be shown such as "Please select a month year to view the data table", and then the data table appears, showing the dataset as per the month year chosen.

Is there any way this can be done? Thank You!

[v-juanli-msft · Accepted solution]

Hi @Anonymous

You want have a an empty table unless a specific slicer item is chosen, right?

Create a measure

Measure = IF(CALCULATE(DISTINCTCOUNT(Table1[date]),ALLSELECTED(Table1[date]))=1,1,0)

Then add this measure to the Visual level filter and set “show item when the value is 1”.

best Regards

maggie

[Anonymous]

@v-juanli-msfthey this works!  However, it does not show when multiple values of the slicer is selected. IS there any way this can be done?

[v-juanli-msft]

Hi @Anonymous

It is a known limitaion, a workaround is to set "show items when value is" as "0" instead of 1 when you select mutiple seletions.

Best Regards

Maggie

[Anonymous]

@v-juanli-msft 

I dont think that would work for me because the datatable would appear then.