Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Hi @bibhash_21 ,
On the matrix option go to values and turn on the Show on rows, that will give you the expected look.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThanks @MFelix
Initail Inventory column is measure not normal column.
can i placed the measure in rows?
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @MFelix
Thanks again.
bellow the initial inventory formula
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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @MFelix
pls go to the below link to download .pbix sample file
there inventory measure is repeated
I don't wnat Invenotry column multiple time.
thanks