Solved: Specific data

Yashh · ‎03-10-2023

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?

Anonymous · ‎03-10-2023

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.

View solution in original post

Anonymous · ‎03-10-2023

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 · ‎03-10-2023

@Anonymous

i do not have a option for this.

Anonymous · ‎03-10-2023

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.