Always show full X-Axis even when there is no data

[dats]

bar charts

Dear all,

I have two simple bar charts. the above one shows spensings, the one on the bottom shares. both are stacked column bar charts and have the same x- axis. this is why there is only one shown. In this example the time on the x-Axis shows data for the bottom chart from week 11 2020 to week 29 2020. for the column chart on the top there is only data available for some of the weeks in the choosen period.

Is there a way I can tell power Bi to always display the full period even if there is no data available so the user read it more easily and doesn't need an extra x axis on the top chart?

[qqqqqwwwweeerrr]

Hi @dats 

Plase check out this video this might help you to h show all the value on axis if you dont have any value. Here is link: https://youtu.be/WqE2As9RlgA?si=7y7S2tu2m7pIck_P

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: www.youtube.com/@Howtosolveprobem

Regards

[SarahHope]

"Show Items with No Data" seems so simple, yet I can't find this option anywhere!  I'm using desktop version Version: 2.131.1203.0 64-bit (July 2024).   It's not under the x or y values for the stacked bar chart visual. 

[Greg_Deckler]

@dats - You can often do this using something like:

Measure =

  VAR __Calc = <some calculation>

RETURN

  IF(ISBLANK(__Calc),0,__Calc)

[mahoneypat]

You could enable Show Items with No Data for that visual, or you can just add "+0" to your measure (so nothing returns blank, and gets filtered out in the visual).

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[dats]

Thank you I did not know about this option.