graph visualization of specific weekday

[pcabrero]

Hello Community;

I've created a simple line graph with dates in the X-Axis. Because client meetings are on mondays, I would need that only Mondays are visible in the axis every day, but not loosing the rest of the values in the graph.

In excel I did it by including limits (min) and units (7) in the settings pannel, but cannot find this functionality in PowerBI.

I've created a column with the weekday, but if I insert the filter weekday=1 (monday) in the graph I loose all the other set of data (not mondays data).

Please, could anyone help me on this?

Many thanks in advance!

[Eric_Zhang]

---

@pcabrero wrote:

Hello Community;

I've created a simple line graph with dates in the X-Axis. Because client meetings are on mondays, I would need that only Mondays are visible in the axis every day, but not loosing the rest of the values in the graph.

In excel I did it by including limits (min) and units (7) in the settings pannel, but cannot find this functionality in PowerBI.

I've created a column with the weekday, but if I insert the filter weekday=1 (monday) in the graph I loose all the other set of data (not mondays data).

Please, could anyone help me on this?

Many thanks in advance!

---

@pcabrero

AFAIK you can't customize the X-Axis. As a workaround, you may try to use a combo chart and create a measure to highlight the Monday values.

Monday values = IF(WEEKDAY(MAX('table'[DATE]))=2,SUM('table'[Value]),BLANK())

[pcabrero]

@Eric_Zhang Thanks for the answer,

Unfortunatelly, this does not fit the client specifications in this case. I will keep on searching.

Again, thanks a lot for your time.