Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
41 | |
27 | |
23 | |
19 | |
16 |
User | Count |
---|---|
54 | |
35 | |
19 | |
19 | |
15 |