Forum Discussion
Table appears only if condition satisfies
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!
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
4 Replies
v-juanli-msftCommunity Support
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
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