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
Scenario
I have a pie chart that was created using Measures.
Measures are calculating the total number of advisers with licensee.
Ask
I want a table that will interact with this pie chart and display the results relevant to the specific pie of the chart. For example, if a pie slice value is 2, then table should automatically filter out and show only 2 corresponding values.
Any suggestions?
Solved! Go to Solution.
Hi @umeshbanga ,
I created some data:
Here are the steps you can follow:
1. Create measure.
the total number of advisers with licensee =
COUNTX(FILTER(ALL('Table'),'Table'[licensee]=MAX('Table'[licensee])),[advisers])
2. In the table visual it is .
3. Pie Visual is.
4. Result:
Click on Pie Visual to filter the table Visual
If I have misunderstood your meaning, please provide your desired output and your pbix without privacy information.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @umeshbanga ,
I created some data:
Here are the steps you can follow:
1. Create measure.
the total number of advisers with licensee =
COUNTX(FILTER(ALL('Table'),'Table'[licensee]=MAX('Table'[licensee])),[advisers])
2. In the table visual it is .
3. Pie Visual is.
4. Result:
Click on Pie Visual to filter the table Visual
If I have misunderstood your meaning, please provide your desired output and your pbix without privacy information.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
@Jihwan_Kim tagging you as you helped me with giving a solution for the measures.
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 |
---|---|
45 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
71 | |
49 | |
45 | |
20 | |
17 |