show visualization for full week even even if only part of week has past.

[moltra]

I am looking for a way to keep my x-axis the same when viewing data.  This is the way the data looks when there is an entire week's data.

This is what I get when I look at the data for the current week. I would like it to keep the 7 day x-axis and just have blanks for the days of the week that do not have data yet.

I have thought about putting in a way to "Fill" the data with 0 for the days that do not have data for the current week, but not sure if that is the best way to do it.

Any advice or recommendations on how to accomplish this?

[parry2k]

@moltra click show items with no data  by clicking on arrow next to the column on x-axis

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[moltra]

@parry2k Did not work, I think this is cause there is no data yet for the future dates.

[v-lili6-msft]

hi  @moltra 

You need to a calendar table, then create a relatinship with data table and use date filed from calendar table in X-axis, and enable "show items with no data" for X-axis.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-show-items-no-data

https://radacad.com/do-you-need-a-date-dimension

Regards,

Lin

[moltra]

Still not working, I think I need to somehow define the data range I want.  I am not doing that now and it shows 7 days when i select a date, but does not when there is a future date.