Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I have an issue I hope you can help solve.
I am creating a tool that shows demand over time in a barchart format. The dates are dynamic so i just have them as "Today" "2 Days" "3 Days" ect...
I want to make a visual showing the demanded amounts over a period of time. When I connect the data and start to make my visual i encounter 2 problems.
1. The graph is using too little space, regardless of how i format the sizing of the bars. I need it to use the whole area i have designated.
2. The X-Axis Labels (the days) won't show up.
Any ideas?
Hi @Anonymous ,
My suggestion is that you can post the output you expected for further discussion or you can change your data model and try other visuals.
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,
Can i use the same selection for axis and values? Since the column i want as the listed x-axis items (days) contain the value i want shown on the barchart. Example below in pics using Excel and the source data. The point is i want the graph to use all the space in the visual and not be narrowed into the center.
Hey @Anonymous ,
you have to unpivot all your columns (Today, Day 1, ... Day x) using Power Query, meaning converting many columns into a attribute (Today, Day 1, ...) value pair. Then you can use the attribute column as axis and the value column as value.
This article describes how to do this in great detail:https://radacad.com/pivot-and-unpivot-with-power-bi
Hopefully, this is what you are looking for.
Regards,
Tom
Hi - thanks for this!
I was really hoping this would solve it. However when i tried to unpivot all columns i got this error when applying query changes.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |