Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

create matrix with multiple columns data

Hi, i am trying to create the summary table using matrix visualization. the data has multiple KPIs columns with values 0,1 and n/a. i want to create like below - KPI  A  B    C    D     E     F 0    ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

    I create a sample pbix file for you, please check if it meets your needs.

    Best Regards

    Rena

Anonymous's avatar
Anonymous
Not applicable
6 years ago

i can not see the attachment option here... do u knw how can i send the excel file to you

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

You can upload the related files to OneDrive for business, then share that link with me. Thank you.

Best Regards

Rena

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

    I create a sample pbix file for you, please check if it meets your needs.

    Best Regards

    Rena

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

    i am facing issue there in onedrive so sharing the data in google doc . i am actually looking for 2 visuals which i created in the google doc with just example data.

    https://docs.google.com/spreadsheets/d/1rB9nbYQYgh9HDWlBRn9XrsYFan_0xyMmVCHNrJUUENk/edit?usp=sharing  

     

    visual 1 -  showing the KPI count as per 1,0,n/a values

    Visual 2 - showing KPI data in table for brand/market which should get updated as per KPI selection. its being difficult for me on how to create the KPI filter. i am able to create the table per KPI but not sure how should i create where all KPI data can be showing on checkbox selection.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    This is awesome , such a simple solution.  thanks a lot Anonymous