Forum Discussion
Dates on x-axis
Hi,
How can I display dates (months and years) on the x-axis in power bi without using any count, sum, or other functions, etc.?
Thank you
6 Replies
- Daniel29195
Community Champion
1.create a measure= blank() ,
2.add it to the visual
3.select show items with no data.
4.
use categorical instead of continuous
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅!
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
In step4, this option dose not appear for me. I'm using a clustered bar chart
- Daniel29195
if the type is ont showing, this means that your date column is of type text. you neeed to change its data type to date .
hope this helps
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅!
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
Hi Banan,
Maybe you can try to use Clustered bar chart, which has X-axis as value column. Stacked column chart has Y-axis as value column.
Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Yes, I use a clustered bar chart, but I want to place dates on the x-axis and products on the y-axis. If I choose to place dates on the x-axis, they should be summarized, for example, by count."
