Column chart with measures as values - how to make categories?

[Anonymous]

Hi everyone

I have a simple column chart with three measures as the values, showing a week on week variance as each value. I want to have each bar labelled based on the measure name along the x-axis rather than having a colour legend. I have read some other forum posts that imply this is possible if I somehow use these measures as categories, but I have no idea how to do this. 

Can anyone help? 

At present my chart looks like this:

I would like the each bar to be labelled along the x-axis, as this would allow me to have each bar the same colour and still be understandable. It would also allow me to space out the bars.

[v-yingjl]

Hi @Anonymous ,

You cannot use a Measure in X-axis. For any column to be used as an axis value, it should be a category. i.e. You should be able to group your entry data based on that column.

So in this case, since this column is a Measure, try to create a column that has these values and can be used to group your data by that. 

Best Regards,
Yingjie Li

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

[Anonymous]

Hi Yingjie

Can this be done in a way that is dynamic, so the chart will still change as I select different options on a slicer? I understand i could hard-code these values in to a new table with enter data but is it possible to have the values in this time performing something like a lookup based on my measure results when the slicer options are selected?

Kind regards

GC4002

[amitchandak]

@Anonymous , refer if my blog on week can help

https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

See if my webinar on Time Intelligence can help: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184


Appreciate your Kudos.