Bar Chart

[BSM1985]

Hi Team,

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

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

[Anonymous · Accepted solution]

Hi @BSM1985,

AFAIK, current power bi bar charts not support to achieve your requirement. Maybe you can take a look at custom visual: advanced trellis/ small multiples - xViz. (you can find it in power bi market place)

In addition, you can try to use r script to plot dynamic graphics based on interactions.

Regards,

Xiaoxin Sheng

[BSM1985]

HI @Anonymous 

Thanks much for your solution.

[Greg_Deckler]

@BSM1985 - Small multiples are not here yet. Soon.