Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
umeshbanga
Regular Visitor

Pie chart with Measure - not filtering the corresponding table

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?

1 ACCEPTED SOLUTION
v-yangliu-msft
Community Support
Community Support

Hi  @umeshbanga ,

I created some data:

vyangliumsft_0-1656380061034.png

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 .

vyangliumsft_1-1656380061037.png

3. Pie Visual is.

vyangliumsft_2-1656380061038.png

4. Result:

Click on Pie Visual to filter the table Visual

vyangliumsft_3-1656380061040.png

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

View solution in original post

2 REPLIES 2
v-yangliu-msft
Community Support
Community Support

Hi  @umeshbanga ,

I created some data:

vyangliumsft_0-1656380061034.png

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 .

vyangliumsft_1-1656380061037.png

3. Pie Visual is.

vyangliumsft_2-1656380061038.png

4. Result:

Click on Pie Visual to filter the table Visual

vyangliumsft_3-1656380061040.png

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

umeshbanga
Regular Visitor

@Jihwan_Kim tagging you as you helped me with giving a solution for the measures.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors