How can I customize Date x-axis label in a bar graph (eg. Have "▲ Jan 2020" for day 1 in Jan 2020)?

[iamriz]

Hello, I have created a sample PBIX practice file (see this link plz) with dates and daily data. I wanted to show "▲ Jan 2020" or have it shown in below target bar graphs (please see pic below), instead of the current "Jan 2020" as x-axis label. This is in order that I will be able to easily identify which daily bar in the graph is Jan 1, 2020 (or day 1 of each month). It would just be easier to do conditional formatting (eg. go for different bar color if it's day 1 of each month), the problem is there are days that the daily count is 0 so it would still be hard to determine which is day 1. Any suggestion on how I can implement this would be highly appreciated. Thank you!

[mwegener · Accepted solution]

Hi @iamriz ,

try this measure to fill the free space of the bar.

first of Month =
IF (
    DAY ( SELECTEDVALUE ( 'Table'[Date] ) ) = 1,
    MAXX (
        SUMMARIZE (
            ALLSELECTED ( 'Table' ),
            'Table'[Date],
            "@Daily Count", SUM ( 'Table'[Daily Count] )
        ),
        [@Daily Count]
    )
        - SUM ( 'Table'[Daily Count] ),
    BLANK ()
)

[iamriz]

Hi @mwegener , thanks for the help. Your suggestion, along with some tweaks, will suffice. 🙂