October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more
Hello Power BI community,
I've been trying to find an answer to the issue that I'm facing. It would be great if someone can assist me with this.
I'm working with energy consumption data from 2017 to 2022 and I am showing the current consumption as per the filtered date using a slicer and showing last year's consumption using SAMEPERIODLASTYEAR.
The following is a visual of my bar chart which is working properly for FY2019, FY 2021, FY2022
Everything seems to work well, except when I'm showing the data for FY2019. The same issue for FY2019 is with any type of bar chart.
The barchart shows thin bars as follows:
Solved! Go to Solution.
What about the related date field in the Consumption_Cost table? Is the date format of that field consistent?
Hi @cpearson, I just used the Date field from the Consumption_Cost table in the bar chart and the slicer and it worked properly for FY2019. I don't know why it was not working when using Date from the Calendar table.
Thank you for following up!!
What about the related date field in the Consumption_Cost table? Is the date format of that field consistent?
Hi @cpearson and thank you for your response!
The current date has a date format and not date time because the underlying data doesn't have date times.
This is a screenshot of that field.
However, if I changed the date field from Date into Month, the bar chart shows properly. It is shown in the following image:
Is your data for that period any different? It's a strange one but the thin bars could be happening because the data is not getting aggregated into months. Is your date field a date or a datetime? Can you share a screenshot of that field?
If your data is formatted to something like this:
but the underlying data has date times it might be causing the issue. Change the column format so you can see the dd/mm/yyyy hh:mm and see if there is any variance in the formatting across the FYs.
User | Count |
---|---|
105 | |
99 | |
98 | |
86 | |
49 |
User | Count |
---|---|
162 | |
142 | |
132 | |
102 | |
63 |