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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply

Table visual Interaction based on the Pie Chart slice selection

Hi Experts,

I want to showcase the table visual data based on the pie chart slice selection.

I have a table already with below data with different columns (cost,scope,schedule etc..) , taking "scope" column as a example here.

 

Sample Source :

xxxbb1xxxbb1yyy661yyy661
RPAGenAIRPAGenAI
YesYesYesYes
NoYesNoYes
YesYesYesNo
NoYesYesNo
AMBERGreenGreenRed

 

In the below table we have used the DAX which is combined the colors and showing higher risk color in the table (eg : for xxxbb1 , we have 2 rows in the source data , Amber & Green results - based on the offer type RPA & GENAI, so in that case Amber is the higher risk than Green , so table shows Amber color icon for xxxbb1)

 

DAX used :

Scope Combined =
VAR A = 'Test Delivery Updates'[Account Name]
VAR B = ADDCOLUMNS(SUMMARIZE(FILTER('Test Delivery Updates','Test Delivery Updates'[Account Name]=A),'Test Delivery Updates'[Scope logic]),"Scope",SWITCH('Test Delivery Updates'[Scope logic],"Red",3,"Amber",2,"Green",1,0))
RETURN MAXX(TOPN(1,B,[Scope]),'Test Delivery Updates'[Scope logic])
 
Scope Dynamic =
IF(
    ISFILTERED('Test Delivery Updates'[Offer Type]) && HASONEVALUE('Test Delivery Updates'[Offer Type]),
    MAX('Test Delivery Updates'[Scope logic]),
    MAX('Test Delivery Updates'[Scope Combined])
)

 

Scope dynamic (scope) is the DAX applied in the table data , based on the Offer type selection (RPA or GENAI) , the color will change. likewise based on the pie chart slice selection the color should change as per the logic .

dinesharivalaga_0-1732200206658.png


When we select Amber in the pie chart , xxxbb1 account is showing , but the same account should show when we click Green in the pie chart as well , but it is not . this is the expectation here .. because we have Green rows also there in the both accounts xxxbb1 & yyy661 .

dinesharivalaga_2-1732199944085.png

dinesharivalaga_3-1732200062205.png

Hope it is understandable , please help to achieve this ..

 

Thanks

DK

 

 

4 REPLIES 4
v-denglli-msft
Community Support
Community Support

Hi @dinesharivalaga ,

I can't reproduce your data, can you provide a simplified version of the PBIX file?

We can better understand the problem and help you. 

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.

 

Best Regards,
Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-denglli-msft
Community Support
Community Support

Hi @dinesharivalaga ,

I did not encounter your problem in my testing.
Both account names are displayed when green is selected for the pie chart.

vdengllimsft_0-1732244614732.png

 

The data table is shown below.

vdengllimsft_1-1732244650927.png


Please see the attached pbix for reference.

Best Regards,
Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-denglli-msft  any lead pls ?

I am using scope logic as a calculated column created based on some logics , but your side you have just created a new column with name of the colors ..

 

When i am using the same logic as of you ..

I am getting this result because of the table having unpivot column applied.

 

dinesharivalaga_0-1732779321380.png

If i choose count(distinct) :

dinesharivalaga_1-1732779367455.png

 

@v-denglli-msft  thanks for your solution 🙂

I noticed that you have used "scope logic" as a values in pie chart instead of "scope combined" , so that the table is not reflecting the both account (different color icons) , but is there any chance to change the color icons in the table visual based on the pie chart selection ? because both accounts are visible when we click "Green" but from the stalkholders/clients side they cannot identify it directly ..
thanks for understanding 🙂

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

Top Solution Authors