Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a report where I am tracking production values daily and putting them on a line graph. I have this by calendar day and I want to be able to have a bookmark where the user will be able to switch between calendar day and business day.
I have a pretty standard date table in my report and then I have an imported table where we have our company business days all mapped out. I successfully have a graph by calendar and and a graph by business day but when I look at the graph by business day there is a gap between the last business day of the last month and the first business day of the next month. For example it goes from 2/20/2020 to 3/1/2020 so there is an odd diagonal line in my line chart. Is there anyway I can get the visual to go from 2/20/2020 to 3/1/2020 without leaving space for the days between? Also if there is just a completely better way to do what I am trying to do I am open to it.
This is how my dates are set up. The date table was created with
DATE =
VAR MINYEAR = YEAR ( MIN ( Production[Day] ) )
VAR MAXYEAR = YEAR ( MAX ( Production[Day] ) )
RETURN
ADDCOLUMNS (
FILTER (
CALENDARAUTO( ),
AND ( YEAR ( [DATE] ) >= MINYEAR, YEAR ( [DATE] ) <= MAXYEAR )
),
"CALENDAR YEAR", "CY " & YEAR ( [DATE] ),
"MONTH NAME", FORMAT ( [DATE], "MMMM" ),
"MONTH NUMBER", MONTH ( [DATE] ),
"WEEKDAY", FORMAT ( [DATE], "DDDD" ),
"WEEKDAY NUMBER", WEEKDAY( [DATE] ),
"Quarter", "Q" & TRUNC((MONTH([Date])-1)/3+1
))
And is linked to my business days table here. The business days are formatted 2/1/2020 to 2/20/2020 so its MM/"Business Day"/YYYY
This is what my graph looks like by business day and ideally I want to remove the yellow gaps between the days on the X axis.
Thank you.
Solved! Go to Solution.
Hi @Anonymous ,
Create a calendar table using below dax expression:
Table 2 = CALENDAR(MIN('Table'[Date]),MAX('Table'[Date]))
Then create relationships between the 2 tables.
Last in the line chart,use the calendar date as the X -axis,and you will see:
For the related .pbix file,pls click here.
Hi @Anonymous ,
Create a calendar table using below dax expression:
Table 2 = CALENDAR(MIN('Table'[Date]),MAX('Table'[Date]))
Then create relationships between the 2 tables.
Last in the line chart,use the calendar date as the X -axis,and you will see:
For the related .pbix file,pls click here.
@Anonymous
Put a visual level filter and remove nonworking days or value =0
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |