Forum Discussion

Rnaval's avatar
Rnaval
Icon for Post Partisan rankPost Partisan
2 years ago
Solved

Having Trouble with a Matrix Visual not working properly

Hi All -

The Matrix Visual is not working properly in some cases.  I've attached the PBIX file and the Excel Data as reference. The problem is the Matrix shows blank items when I select or filter on the TLS Vulnerability items in one of the above graphs or slicers. There are some other items that behave the same way. 

 

https://www.dropbox.com/scl/fi/l4028kibtjyeggi63ytpw/Tenable-Extract.xlsx?rlkey=mgec48r2rjtxd5res8c91yg3l&dl=0

https://www.dropbox.com/scl/fi/7uvtber3oyvp5hp4wucak/VM-Tenable.pbix?rlkey=tkm5ji1r6dq3l4jv2ov0ekb8u&dl=0

 

Is it a problem with my data or something else? Appreciate any help on this...

 

Thanks...Rohit

 

  • Hello Rnaval 

    you can just add any measure example : 

     

    from the table extract, and things should work fine . 

     

     

     

    If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit that  thumbs up button 🫡👍

     

     

5 Replies

  • Daniel29195's avatar
    Daniel29195
    Icon for Community Champion rankCommunity Champion

    Hello Rnaval 

    you can just add any measure example : 

     

    from the table extract, and things should work fine . 

     

     

     

    If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit that  thumbs up button 🫡👍

     

     

    • Rnaval's avatar
      Rnaval
      Icon for Post Partisan rankPost Partisan

      Excellent, Thank you so much for everyone's help.

  • Daniel29195's avatar
    Daniel29195
    Icon for Community Champion rankCommunity Champion

    Rnaval 

     

    since you are not adding any measure to the table , power bi internally adds one . 

    in your case the one added is  : 

    Vulnerability Priority Rating

     

    if you check the data for this column, -->  it is blank for TLS  

     

     

    , and that is why when you select tls , it is returning blank for the rows of the visual, thus power bi wont display anything . 

     

     

     

    adding a measure will force power bi to use your measure and not some random measure to display your data .

     

     

     

     

    hope this helps 

     

     

     

    If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit that  thumbs up button 🫡👍

     

  • Rnaval's avatar
    Rnaval
    Icon for Post Partisan rankPost Partisan

    One last question - where is the new measure that was created? I don't see it...