Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi community,
I am new to Power BI and have learned a lot from your posts. Thank you all very much.
Today I met a question. Any answer and hint are much appreciated.
I have a table like,
Type 1 | Type 2 | Type 3 | id |
Yes | Yes | Yes | 1 |
No | No | Yes | 2 |
Yes | No | No | 3 |
I want to add a filter on dashboard, which lists 3 values: A, B and C
when I select A, I want to the charts to show Type 2 = Yes. when I select B, I want the records with Type 3 = Yes. When I select C, I want to see all records. How to do this?
Thanks in advance!
Solved! Go to Solution.
@and2022 , Unpivot the type column in power bi, and create A,B,C when the type is yes
Or you need to have table with A,b,c as rows, and based on each selection return values
Switch(selectedvalues(Type[Type]),
"A",calculate(Count(Table[id]), filter(Table, Table[Type1] ="Yes")) ,
"B",calculate(Count(Table[id]), filter(Table, Table[Type2] ="Yes")) ,
"C",calculate(Count(Table[id]), filter(Table, Table[Type3] ="Yes"))
)
Got it. Thank you.
@and2022 , Unpivot the type column in power bi, and create A,B,C when the type is yes
Or you need to have table with A,b,c as rows, and based on each selection return values
Switch(selectedvalues(Type[Type]),
"A",calculate(Count(Table[id]), filter(Table, Table[Type1] ="Yes")) ,
"B",calculate(Count(Table[id]), filter(Table, Table[Type2] ="Yes")) ,
"C",calculate(Count(Table[id]), filter(Table, Table[Type3] ="Yes"))
)
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
142 | |
80 | |
64 | |
52 | |
48 |
User | Count |
---|---|
212 | |
89 | |
79 | |
68 | |
60 |