Forum Discussion

SuayMak's avatar
SuayMak
Regular Visitor
1 year ago
Solved

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

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

 

CategoryValueSalesTTL SQ
A6026015600
B101001000
C201402800
D3020600
A71453195
B10550
C1120220
D50201000

 

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

Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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

10 Replies

  • Akash_Varuna's avatar
    Akash_Varuna
    Super User
    1 year ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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

  • SuayMak's avatar
    SuayMak
    Regular Visitor
    1 year ago

    Hi Akash_Varuna  and Anonymous ,

     

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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's avatar
      SuayMak
      Regular Visitor
      1 year ago

      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 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi SuayMak,

     

    Not bale to access the Data link.

     

    Regards,

    Prasanna Kumar

    • SuayMak's avatar
      SuayMak
      Regular Visitor
      1 year ago

      Hi Anonymous ,

       

      Apologies for that.

       

      How about this >>Data 

       

      Thank you.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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