Create both Pie Chart and Stacked Column Chart using the same dataset

[SuayMak]

Hello everyone, I would like to create a visualization based on the following requirements..

Category	Value	Sales	TTL SQ
A	60	260	15600
B	10	100	1000
C	20	140	2800
D	30	20	600
A	71	45	3195
B	10	5	50
C	11	20	220
D	50	20	1000

based on above table, to plot 2 charts, pie chart using "TTL SQ" and stacked column chart using "Value"

If select A, Pie chart will show total only (do not have breakdown), but stacked chart will have the breakdown into B, C and D, however, when select other than A, both Pie chart and stacked column chart will show as it is

Looking for the support. 

thank you

[v-pgoloju]

Hi @SuayMak,

Just following up could you please share a bit more clarity on the expected output or your specific requirement? This will help ensure I’m guiding you in the right direction.

Looking forward to your response.

Thanks & Regards,
Prasanna Kumar

[v-pgoloju]

Hi @SuayMak,

Just wanted to fallow up, If you happen to find a solution on your own in the meantime, please do share it here as well it would be really helpful for other community members who might face the same issue in the future. Your input can make a big difference in resolving similar challenges faster. Looking forward to hearing from you.

Thanks & Regards,

Prasanna Kumar

[v-pgoloju]

Hi @SuayMak,

Apologies, but I’m not entirely clear on the expected output. Could you please provide a bit more clarity or detail on the requirements? This will help ensure I assist you accurately.

Thanks & Regards,

Prasanna Kumar

[v-pgoloju]

Hi @SuayMak,

Not bale to access the Data link.

Regards,

Prasanna Kumar

[SuayMak]

Hi @v-pgoloju ,

Apologies for that.

How about this >>Data 

Thank you.

[v-pgoloju]

Hi @SuayMak,

Thank you for reaching out to the Microsoft Fabric Forum Community.

Would you be able to share a sample .pbix file or some mock data that replicates the issue? Even a simplified version would be really helpful. Additionally, if you could describe or show the expected output particularly how the Pie Chart and Stacked Column Chart should behave based on the Category selection that would give us a clearer picture and help us provide a more targeted solution.

Best regards,
Prasanna Kumar

[SuayMak]

Apologies that my previous query might not clear.

Anyway, I have prepared the mock data and expected output image as suggested.

You may access from here >> Data 

[SuayMak]

Hi @Akash_Varuna  and @v-pgoloju ,

Thank you for your response and support.

However, I am still very new to Power BI, therefore, appreciate if you could elaborate more.. apprecaite it.

Thank you.

[v-pgoloju]

Hi @SuayMak,

Thank you for reaching out to the Microsoft Fabric Forum Community. and also thanks to @Akash_Varuna for prompt and helpful response.

Just checking in to see if the suggestion shared helped address your query. Let us know if you need any further clarification or support we’re happy to assist!

Best regards,
Prasanna Kumar

[Akash_Varuna]

Hi @SuayMak For this, you can use both a pie chart and a stacked column chart based on the same dataset. Use the slicer on Category, and apply conditional formatting or DAX logic to control visual behavior. For example, show full pie only when "A" is selected, and breakdown in stacked chart for others. Use IF SELECTEDVALUE(Category)="A" logic to adjust visuals accordingly.