Matrix Visual Help

[Jaymez_90]

Apologies if this lives somewhere, first time post!

I have a matrix visual that shows me customers & pallets delivered per Month/

I want to add the Value of the delivery to the Matrix.

However, I only want to see this as a total on the end of the Matrix, not broken down by month.

Can anyone help?

[Anonymous]

Hi @Jaymez_90 

Thank you very much Sahir_Maharaj for your prompt reply.

According to the default design of Power Bi Desktop, you may not be able to achieve the expected effect by writing Measure. I can provide some alternative methods, maybe it is helpful to you:

First, create a measure to calculate the total.

TotalDeliveryValue = SUM('Table'[DeliveryValue])

Drag the newly created measure TotalDeliveryValue to the Values ​​section of the matrix.

Search for the "Text Wrap" properties of the Matrix visual, and then we can turn off "Text Wrap" for both the "Values" and "Column headers".

Then you can drag the column which you do not want to display it to hide.

Solved: Matrix - Hide a column in visual but consider in c... - Microsoft Fabric Community

Regards,

Nono Chen

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

[Jaymez_90]

Sorry, should add, I just want to see the value at the end 🙂

[Jaymez_90]

Many thanks for the response!

Unfortunatley, this approach still breaks each total down by month 

I amended your DAX to match the correct tables:

ShowInTotalOnly =

IF(

    NOT ISINSCOPE('SummaryTable'[Month]),   -- Check if 'Month' is not in scope

    [TotalDeliveryValue],                   -- Show the 'TotalDeliveryValue' measure

    BLANK()                                 -- Return blank when 'Month' is in scope

)

[Sahir_Maharaj]

Hello @Jaymez_90,

Welcome to the community 🙂

Can you please try this approach:

1. Create DAX measure that calculates the total value of delivery

TotalDeliveryValue = SUM(Deliveries[DeliveryValue])

2. Modify the Measure to Show Only in Totals

ShowInTotalOnly = 
IF(
    NOT ISINSCOPE(Dates[Month]),
    [TotalDeliveryValue],        -- Show value only if it's not in the scope of the month
    BLANK()                      -- Otherwise, show nothing
)

Here's a few resources worthwhile exploring: 

• https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-matrix-visual?tabs=powerbi...
• https://www.youtube.com/watch?v=ExCD0vM-OEU

Hope this helps.