Dynamic Table

[maurolpj]

Good afternoon,

does anyone know a way to put a table at power BI desktop which will be seen only if an specific data was selected? For example, I have, as database a list of failures divided in different systems. I would like to do a kind of report that will show up a table summarizing the failures when I select the system, otherwise, the table must be empty.

Thanks

[v-yulgu-msft · Accepted solution]

Hi @maurolpj,

Create a measure for that column you want to apply filters on, rather than directly dragging the column into visual.

Please check below example.

isselected = CALCULATE(ISFILTERED(table[Country]),ALLSELECTED(table))

Measure country = IF([isselected]=TRUE(),SELECTEDVALUE(table[Country]),BLANK())

Best regards,

Yuliana Gu

[maurolpj]

Good afternoon, does anyone know a way to put a table at power BI desktop which will be seen only if an specific data was selected? For example, I have, as database a list of failures divided in different systems. I would like to do a kind of report that will show up a table summarizing the failures when I select the system, otherwise, the table must be empty.

Thanks