Forum Discussion

Yashh's avatar
Yashh
Helper II
3 years ago
Solved

Specific data

Hello Everyone, 

I wanted help whit my dashboard. I want this data to be displayed in my dashboard for the follwing material.

 

 

But when i did I am  getting the follwing data back .

 

 How can I solve this?

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    That is because you are using a Matrix visual. 

    Question you need to ask here is do you really need to use the Matrix visual for your case? Or using Table visual will also serve your purpose?

     

    If you can use Table visual, then you can easily opt for this option of "Don't Summarize" the values.

     

    But if your option is only the Matrix visual then unfortunatuely, Matrix visual doesn't allow this option. So, in Matrix visual, you can't really have multiple values against one material (in your case 128) What you can do in this scenario is create a measure like this, 

     

    Material Value = MAX(Table[Material])

     

    Using this measure, you will be able to get the maximum value for your Material (i..e, for Material = 128, it will return max Stock value) but it will ignore all the other values.

     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    That is because Power BI automatically aggregates the data when you place it in a Matrix.

     

    What you can do is go to your Fields in Power BI and then click on "Sum of Material", and then click on "Dont Summarize"

     

     

     

    This will fix your problem. 

    • Yashh's avatar
      Yashh
      Helper II
      3 years ago

      Anonymous  

      i do not have a option for this.

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        That is because you are using a Matrix visual. 

        Question you need to ask here is do you really need to use the Matrix visual for your case? Or using Table visual will also serve your purpose?

         

        If you can use Table visual, then you can easily opt for this option of "Don't Summarize" the values.

         

        But if your option is only the Matrix visual then unfortunatuely, Matrix visual doesn't allow this option. So, in Matrix visual, you can't really have multiple values against one material (in your case 128) What you can do in this scenario is create a measure like this, 

         

        Material Value = MAX(Table[Material])

         

        Using this measure, you will be able to get the maximum value for your Material (i..e, for Material = 128, it will return max Stock value) but it will ignore all the other values.