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.
Hi to all community!! Have a nice day!
today my problem is: how to show in a pBI report table a colum or another when is filtered a value or another
Suppose you have a year week filter active on a report page like this (with radio button check):
o 32
o33
o34
o35
and so on
Suppose you have imported an Excel table like this:
UserID | City | Number | Value 1 | Value 2 | Value 3 | ...
001 Rome 01234567 18% 107% 67% ...
I want that when filter is checked on a value the pBI report table shown is:
o 32 (is checked)
UserID | City | Number | Value 1
001 Rome 01234567 18%
or
o 33 (is checked)
UserID | City | Number | Value 2
001 Rome 01234567 107%
or
o 34 (is checked)
UserID | City | Number | Value 3 |
001 Rome 01234567 67%
and so on
I try with conditional statment or DAX VAR but I didn't find the right way ...
Can someone help me in finding the right solution?
Thanks in advance
Ago
Hi @AgoZ_KH ,
How to ensure that whether Oxx is checked?
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
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 |
---|---|
105 | |
96 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |