Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
84 | |
71 | |
71 | |
68 | |
55 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |