Forum Discussion

DataVizzer's avatar
DataVizzer
New Member
3 years ago

Matrix Visual - Dynamic X Axis

Hi Folks,

 

is it possible to create something like the following matrix in Power BI Desktop:

 

  • the x-axis on top should be dynamic (by using parameters the x-axis should increase / decrease e.g. from 1-10 or 3-5 or 20-50)
  • the first column (Level 1 - Level 5) represents my row labels 
  • the values X or O represent meter values

 

 12345
Level 1XOXXO
Level 2OOXXX
Level 3XXXXX
Level 4OOXXO
Level 5OXOOO

 

I've spend some time trying to use the matrix visual but it doesn't work. How can I built this?

Need Help

2 Replies

  • MFelix's avatar
    MFelix
    Super User
    3 years ago

    Hi DataVizzer ,

     

    You want the value to be dynamic based on what data?

     

    Can you share a little bit more information on the details of the model?

    • DataVizzer's avatar
      DataVizzer
      New Member
      3 years ago

      Hi MFelix,

       

      I want the x-axis (on top, with the example values 1-5) to be dynamic based on slicer selection. In addition to that, I also want the y-axis to be dynamic. Users should be able to select the width for the x-axis (e.g. defined by values between 1-10) and also the specific levels (these are the rows).

       

      This is my input table:

       

       

      Hope this helps and thanks for the support!