Add a measure next to Matrix visual using one visual

[cbschley]

I am trying to add an additional measure next to a matrix. The Matrix uses 'Month' along the top, and I want to input another measure next to it without creating a separate visual.

Currently I have this set up as two separate visuals, but this creates problems in a number of ways (users trying to export, filtering & resizing of visuals). Is it possible to build something like this using one visual?

[Anonymous · Accepted solution]

Hi @cbschley ,

I create a table as you mentioned.

Then I create a measure and here is the DAX code.

Measure = 
CALCULATE ( SUM ( 'Table'[Total] ), ALLEXCEPT ( 'Table', 'Table'[Name] ) )

In Matrix in Power BI Desktop, the Measure added in Values will only be shown after each column.

So I think you can show the Measure separately.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sevenhills]

No straight forward way of doing. I recommend to check these and see if it helps!
https://learn.microsoft.com/en-us/power-bi/create-reports/end-user-show-data?tabs=powerbi-desktop

Alternatively, you can copy the column chart visual, past it below the original chart, and change the new, duplicated chart to a table visualization and add more measures per your needs.

If you are ok to have a custom/import visual try this free one:
https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa200000675?tab=overview