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!

     

MFelix's avatar
MFelix
Super User
4 years ago

Hi jie ,

 

If you create a matrix with the following setup you will get what you need:

  • Rows:
    • StimeZone
    • Equipment
  • Columns
    • Can be empty or with one of the above columns has you prefer
  • Values
    • TraineeID (aggregation count)

 

That should give expected result.

  • 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
      Super 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.

    • v-kelly-msft's avatar
      v-kelly-msft
      Community Support
      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!