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 of then, the column STimeZone of my table is upload.

 

 

 

My question is, I want to create a matrix table with resumen of How many trainers (count traineeId) by equipment and StimeZone I have?

Plz, I need your help.

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!

     

4 Replies

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