The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi everyone,
I am new to PowerBI. I am trying to create two filters to allow the chart to switch between top2 shares and top3 shares value. I am currently have charts below with top 2 shares as 'value'. I created top 2 and top3 shares as measuremnet value. how do I custom the data to make the charts to be able to switch back and force between top 2 and top3 share value? Thanks in advance
Solved! Go to Solution.
Hi @Kayla_Xue ,
I created a sample. You could reference it to have a try. Please follow the steps.
Measure =
var a = SELECTEDVALUE('Filter Table'[Column1])
return
IF(ISFILTERED('Filter Table'[Column1]),IF(a= "Top 2",[Top 2],[Top 3]),BLANK())
Note: The measures of "Top 2" and "Top 3" are just sample. They are not really top values. Please change them to your own measures.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
this is the chart in case you guys cant see it
Hi @Kayla_Xue ,
I created a sample. You could reference it to have a try. Please follow the steps.
Measure =
var a = SELECTEDVALUE('Filter Table'[Column1])
return
IF(ISFILTERED('Filter Table'[Column1]),IF(a= "Top 2",[Top 2],[Top 3]),BLANK())
Note: The measures of "Top 2" and "Top 3" are just sample. They are not really top values. Please change them to your own measures.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
264 | |
120 | |
115 | |
83 | |
70 |