Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
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
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |