Forum Discussion

PowerBI-P's avatar
PowerBI-P
Frequent Visitor
5 months ago
Solved

Matrix table in Power bi

Hi All,   Please help me with this problem if you have any idea. I'm trying to work on matrix in Power BI as given below example.   Then I created Average measure to get the values after "...
Need Help
  • danextian's avatar
    danextian
    5 months ago

    Hi PowerBI-P 

    Create a display table which is disconnected from the rest of the model, containing the column header values.

    Create a measure referencing the table

    Display Table Measure = 
VAR _total = [Total Transactions]
VAR _avg =
    AVERAGEX ( ALLSELECTED ( Dates[Day of Week Short] ), [Total Transactions] )
VAR _day =
    CALCULATE (
        [Total Transactions],
        TREATAS ( VALUES ( DisplayTable[Day of Week Short] ), Dates[Day of Week Short] )
    )
RETURN
    SWITCH (
        SELECTEDVALUE ( DisplayTable[Day of Week Short] ),
        "Total", _total,
        "Avg", _avg,
        _day
    )

    Please see the attached pbix.

     

Natarajan_M's avatar
Natarajan_M
Super User
5 months ago

Hi PowerBI-P , If the template is fixed and still you want to get data in the format we can make use of the SVG 


Matrix.pbix
Please find the attached pbix for more details.

Thanks

If this response was helpful in any way, I’d gladly accept a kudo.
Please mark it as the correct solution. It helps other community members find their way faster



  • PowerBI-P's avatar
    PowerBI-P
    Frequent Visitor
    5 months ago

    Hi Natarajan,

     

    Sorry for the late reply due to on holidays. 

     

    Thank you for your help. I tried to open Matrix.pbix file but it is not allowing me becuase my IT has blocked the site of outside links. 

    Is it possible to send Matrix.pbix file to my personal email if I mention here, please?

    Thanks,

    P