Forum Discussion

BSM1985's avatar
BSM1985
Helper IV
5 years ago
Solved

Dynamic Charts

Hi Team,


I have a report with a slicer 'State', 'County' and 'Population' on the bar chart.


Consider a case, the state Alabam has 4 counties. Now the requirement is when I choose State Alabama in the slicer the report should generate 4 seperate bar grphas as shown below.

Another example, If there are 10 counties then my report should generate 10 seperate bar graphs, one for each county.

sample output here:
https://1drv.ms/u/s!ArRkjWtfVLy-atPiAqZk4b2l6fA

 

Is that possible in Power BI to generate the charts dynamically like this.

.pbix here
https://1drv.ms/u/s!ArRkjWtfVLy-awRzWcKRZHyiwO4

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi BSM1985 ,

     

    According to what I have learned, I can only do this, you can download my pbix file to view.

     

    Best Regards,
    Stephen Tao

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

5 Replies