Forum Discussion

Helper II

4 years ago

Solved

How to change format in bar chart

Here is what I got. I need to have 3 slicers or even 4 later for different purpose. I was wondering is it possible to create one like this(below picture) . There are 3 business unit in X-a...

Need Help

Show and Tell

Anonymous
4 years ago
Hi tyan ,

You need a table like my sample.

Add [Business Unit] in visual axis, add Legend in visual in axis and value in value.

Then add DimSeason, DimCategory, DimCountry .. etc tables in your data model and relate them with this data table. Then you can build slicers by these Dim tables.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
How to change format in bar chart.pbix17 KB

Anonymous

Not applicable

4 years ago

Hi tyan ,

You need a table like my sample.

Add [Business Unit] in visual axis, add Legend in visual in axis and value in value.

Then add DimSeason, DimCategory, DimCountry .. etc tables in your data model and relate them with this data table. Then you can build slicers by these Dim tables.

Best Regards,
Rico Zhou

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

How to change format in bar chart.pbix17 KB