Add total bar to bar chart when multiple values are selected

[Vanshikaw14]

Hi,

I have a requirement where I have to add a total bar to a bar graph but it should be visible only when 2 or more values are selected in the slicer. Otherwise when only one value is selected it should show only that bar.

It should look like the below screenshots.

Regards,

Vanshika

[Greg_Deckler · Accepted solution]

@Vanshikaw14 OK, I was able to do it using the following measure coupled with a disconnected table. See PBIX attached below signature.

Measure = 
    VAR __Tiers = DISTINCT( 'Table'[Tier] )
    VAR __Count = COUNTROWS( __Tiers )
    VAR __ShowTotal = IF( __Count > 1, TRUE(), FALSE() )
    VAR __Tier = MAX( 'Tiers'[Tier] )
    VAR __Result = 
        SWITCH( TRUE(),
            __Tier IN __Tiers, SUMX( FILTER( 'Table', [Tier] = __Tier ), [Value] ),
            __Tier = "Total" && __ShowTotal, SUMX( 'Table', [Value] ),
            BLANK()
        )
RETURN
    __Result

[Vanshikaw14]

Thank you @Greg_Deckler for the solution. It is solving my use case.

[Greg_Deckler]

@Vanshikaw14 Pretty sure that would require a disconnected table for your x-axis and then a measure that included the logic on whether to return a value or not. I'll see if I can mock it up or perhaps you could post sample data.