Defaulting the stacked column chart to the maximum month

[Anonymous]

My user has requested that the stacked column chart default to highlighting the maximun month while also displaying the rest of the months in the chart. Is there a way to set a default when the report opens to highlight the maximum month in the chart without loosing the rest of the chart?

Thanks, Mark

[amitchandak]

@Anonymous , stacked visual do not support conditional formatting with legents. I doubt you can highlight.

Or you can have stacked line with the line having value for the current month that might display dot on the current month

if(Max(Date[Month]) = format(Today(),"MMM-YYYY"), [Measure], blank())

//Use month format you are using.

[Anonymous]

Thanks for your suggestion. If the result of this this formula is the current month won't that month be the only month in the chart?

[v-xuding-msft]

Hi @Anonymous ,

Have you resolved this issue? If the answer is helpful, please accept it as solution. Others will benefit from this thread. Thanks!

[v-xuding-msft]

Hi @Anonymous ,

Please follow this to have a try:

A disconnected table:

Date = CALENDAR(MIN('Table'[Date]),MAX('Table'[Date]))

Measures:

Total sales =
VAR selectedsales =
    CALCULATE (
        SUM ( 'Table'[Sales] ),
        FILTER (
            'Table',
            'Table'[Date].[Month] = SELECTEDVALUE ( 'Date'[Date].[Month] )
        )
    )
RETURN
    IF (
        ISFILTERED ( 'Date'[Date].[Month] ),
        selectedsales,
        CALCULATE ( SUM ( 'Table'[Sales] ) )
    )

Measure =
VAR maxdate =
    MAXX ( ALL ( 'Table' ), 'Table'[Date] )
RETURN
    IF (
        ISFILTERED ( 'Date'[Date].[Month] ),
        "Blue",
        IF ( MAX ( 'Table'[Date] ) = maxdate, "Blue", "Gray" )
    )

 

You could reference the document to learn more about conditional formatting and change other colors in the formula.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting#color-...