Forum Discussion
Bar Chart
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
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
3 Replies
BSM1985 - Small multiples are not here yet. Soon.
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
HI Anonymous
Thanks much for your solution.
