cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pcabrero Frequent Visitor
Frequent Visitor

graph visualization of specific weekday

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!

 

2 REPLIES 2
Moderator Eric_Zhang
Moderator

Re: graph visualization of specific weekday


@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())

Capture.PNG

pcabrero Frequent Visitor
Frequent Visitor

Re: graph visualization of specific weekday

@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.