Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
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.
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
@Anonymous , refer if my blog on week can help
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
179 | |
108 | |
104 | |
71 | |
70 |