Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |