Forum Discussion

utsavlexmark's avatar
utsavlexmark
Helper III
2 months ago
Solved

Interactive Pie Chart - Based on Metrics

Hello All, I don't know whether it is technically possible or not, but curious to know. I want to create a piechart where "Campaign Types" will be the legends and it will be change based on selecti...
  • grazitti_sapna's avatar
    2 months ago

    Hi utsavlexmark,

     

    Yes, Absolutely. You can acheieve this by creating measures and then using them as field parameters by going to 

    Modeling β†’ New parameter β†’ Fields. 
     
    Then Create a pie chart use Campaign type as legends and Field (Parameter) from "Field parameter" table which you just created.
     
    Attached is the sample .pbix file for your reference.
     
    🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
    πŸ’‘ Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
    πŸŽ– As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
    πŸ”— Curious to explore more? [Discover here].
    Let’s keep building smarter solutions together!