Bringing totals in clustered column chart with filters

[Wasi]

Hi Members,

I am new to Power BI and wanted to ask you guys if there is any way to bring Total in clustered column chart whereby i have filters on the x-axis (screenshot attached). I am also sharing same result from Tableau as well where it is very much easier.

Thanks in advance!Power BITableau

[Anonymous]

Hi @Wasi ,

I made a simple PBIX file for your reference:

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[Wasi]

Thanks for sharing the pbix file. I got the Measures and total column. However, if you see in my attached pbix link and screenshot that Measure 2 is also showing as a column for "Installationen" row as well which we do not want. Measure 2 is only for "Storungen".

I would appreciate if you can help with this.

PBIX link:

https://www.transfernow.net/dl/20220920wHd9t6m5

[Anonymous]

Hi @Wasi ,

Please try this measure:

Measure2 = 
IF (
    MAX ( 'export'[Geschäftseinheit] ) <> "WIL_Installationen",
    CALCULATE (
        COUNT ( 'export'[Geschäftseinheit] ),
        'export'[Geschäftseinheit] = "WIL_Störungen"
    )
)

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[Wasi]

I tried and also saw your PBIX. However, Installationen figures / column is also showing with Storungen column, which we do not want. We just want to show column bars for WIL_Installationen, WIL_Storungen and their Total as a column bar (see attachments)Tableau

[Greg_Deckler]

@Wasi Create a measure, Total = [Measure1] + [Measure2]. Put it in your Y-Axis field well along with your other measures.

[Wasi]

I didnt get it.. Can you please elaborate a little more.. I have filters on Geschaftseinheit (X-Axis) and need to have totals on this filter for Y-Axis.