Forum Discussion

jie's avatar
jie
New Member
4 years ago
Solved

Create Matrix chart from table chart

Hi all,   I need your help with this problem. I create a table chart with selected value using selectedvalue function. For example, I have a filter with distincts time zones, when I clic in some o...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    4 years ago

    Hi  jie ,

     

    Create a dim table using all the measure values as the column values,such as below:

    Then create a measure to get what you need:

     

    Measure =
SWITCH (
    SELECTEDVALUE ( dim[Stimezone] ),
    "Othertimezone",
        CALCULATE (
            SUM ( 'Table'[Value] ),
            FILTER ( 'Table', 'Table'[Stimezone] = "Othertimezone" )
        ),
    "Sametimezone",
        CALCULATE (
            SUM ( 'Table'[Value] ),
            FILTER ( 'Table', 'Table'[Stimezone] = "Sametimezone" )
        )
)

     

    I made a simple sample for reference,pls check attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my reply as a solution!

     

jie's avatar
jie
New Member
4 years ago

Thank u for your answer Miguel.

The problem is that STimeZone is a measure. So, I can't use this for matrix. 😞

MFelix's avatar
MFelix
Icon for Super User rankSuper User
4 years ago

Do you need to show the timezone on the matrix?

 

You can create the matrix has I explained but without the measure. Then place the measure has a card to serve has title or similar.

 

If you can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.