Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |