Dynamic Charts

[BSM1985]

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

[v-stephen-msft · Accepted solution]

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.

[BSM1985]

Hi @v-stephen-msft 

Thanks much for your solution.

[amitchandak]

@BSM1985 , first link is not showing anything

[BSM1985]

Hello @amitchandak  and @Greg_Deckler 

Sorry, here are the links

Sample output:

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

.pbix file

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

[Greg_Deckler]

@BSM1985 Small multiples are not here yet if that is what you are going for. I can't get to first link.