can I put the mesure column in rows in power bi matrix visual

[bibhash_21]

Hi Power BI Developers,

I have a senorio like.

I have 3 normal column one date column and 2 mesure colum and i created a matrix visual report. like

look into the image, the inventory field is repeating for all date columns. So i want to column effects only on Actual amount sum not inventory or can i put the mesure column in Rows?

Pls help me guys

thanks

[MFelix]

Hi @bibhash_21 ,

On the matrix option go to values and turn on the Show on rows, that will give you the expected look.

[bibhash_21]

Hi @MFelix 

thanks for reply

when I turn on the 'Show on rows' then the matrix report looks like

I want to "Initial inventory" column like "Address" column becouse Initial Inventory value not very according to drop date, so if any other way to achive the functionality? pls let me know.

Thanks

[MFelix]

Hi @bibhash_21 

Is the initial inventory a column or a measure? if it's a column place it on the rows part of the matrix.

[bibhash_21]

Thanks @MFelix 

Initail Inventory column is measure not normal column.

can i placed the measure in rows?

[MFelix]

Hi @bibhash_21 ,

You can only use the measures in the values part. You can create a calculated column for that value maybe can be an option.

What is the intent of having the initial inventory? You want to have the initial inventory and then the calculeted measure with the values?

Something similar to this format:

Description - Initial inventory - Date 1 - date 2 - Date zzz?

Regards.

MFelix

[bibhash_21]

Hi @MFelix 

Thanks again.

bellow the initial inventory formula

Inventory=CALCULATE(SUM('Merge Table Chemical Inventory'[Quantity]),FILTER('Merge Table Chemical Inventory','Merge Table Chemical Inventory'[Initial Inventory]=True),FILTER('Merge Table Chemical Inventory','Merge Table Chemical Inventory'[Inventory Date].[Date]<=(DATE(2019,6,30))))

Thanks

[MFelix]

Hi @bibhash_21 ,

To what I can understand you are getting the information from an inventory table that is filter out based on date correct?

Is it possibile to sharea sample file? I have some ideas what can be done but without the setup it's difficult to point you in the rigth direction.

[bibhash_21]

Hi @MFelix 

pls go to the below link  to download .pbix sample file

Sample .pbix file 

there inventory measure is repeated

I don't wnat Invenotry column multiple time.

thanks