Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I'm trying to figure out how to add purchase details to an inventory summary. I can't attach a pbix, but I'll try to provide all the details I can.
I would like to have the values side by side, but I would be open to a tooltip that displays the values if what I am trying to do is not possible.
Here is an example of my data model.
Here is an example of the matrix in the visualization pane.
I tried pulling in the PO Number directly and my options are aggregated.
First, Last, Count (Distinct), Count, which is not what I want.
I have tried a number of things but cannot find a solution.
This is the current result.
This is the desired result
As you can see, the result produces each invididual PO and details associated with it.
The alternative would be to create a tooltip visual to show the purchases:
Thanks.
Hi @Daniel29195,
Thanks for the fast reply. Unfortunately that doesn't seem to work for my situation. My later columns, sum(qty) and sum(cost) do not respond. They remain aggreagated as one value for each. I don't want to change to text either because I use them for other calculations.
Also my other measure Vendor ID* does not respond either. I have a situation where one vendor ID is blank and the other is not, and it mismatches the line associating it with the first PO when it is associated with the second PO.
use the concatenatex function .
this is the pattern :
concatenatex ( values(tbl_name[col_name] ) , tbl_name[col_name] , unichar(10) )
unichar (10 ) == line break .
let me know if this helps .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🙏
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
89 | |
86 | |
79 | |
69 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |