Forum Discussion
How to get different measures in report
Hi dears, I'm new both on PBI modeling and this great community!
I'm in charge to develop a new report showing the inventory level both in pcs and value but only one value at time.
I've the following table:
PRODUCT WAREHOUSE QTY VAL
Bike Canada 500 5000$
Cars USA 50 12000$
and so on.
How can get a report showing alternatively QTY and VAL?
I've tried to use the PARAMETER by selecting FIELDS instead of MEASURES but I only retrieve the LABEL (QTY/VAL) instead of the current measure.
Could you kindly explain me what is the best way to manage this issue? Have you any link "graphical" to show me the way since I'm a newbie?
Thanks in advance
emm980 You can create this whenever you want.
Measures doesn't depend on the position of where it is.
7 Replies
- rajulshah
Resident Rockstar
- emm980New Member
Thanks rajulshah. It is just what I would reproduce. However I'm bit confused about this section
where have I to create these new measures? In table DTDates or FTSales (following the example)?
- emm980New Member
ok... I've better read... in FTSales. And, what about the "Dynamic Measure" where have I to insert? In the created slicer?
- FreemanZ
Super User
hi emm980
best way is to use field parameter to call for different measures one at a time:
https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
- emm980New Member
thanks FreemanZ... I've just followed this link before edit my first post!! Only obtained to have in any row Qty o Val!!
- emm980New Member
Thanks so much to all! It is working very well.