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.
This is the situation:
So I have data in with Type Actual. Now we will load also LBE1, 2 etc.
If I would put 'Type' in the legend I would get a column for every Type.
That is what we want but we also would like the countries stacked like in this picture.
Is it even posible to have this setup, so with period on x 'Volume' on y and country in legend, and still have multiple values on Y?
Was thinking of making a switch with 'ACT Vol' "LBE1 Vol" etc and depending on the type selected it would put that on Y.
But I fear it will only sum Actual and LBE together instead of making separare columns correct?
Solved! Go to Solution.
Thanks @v-binbinyu-msft but I used the x-axis! Put period and type on the x-axis and this was I get 2 columns per period. One with the actuals other with LBE:
Too fixated on the y-axis to show 2 different volumes. But the key was in the x-axis spliting the volume into a type.
(note: you need to have a column in your data that determines if an amount is an actual or an LBE)
Thanks @v-binbinyu-msft but I used the x-axis! Put period and type on the x-axis and this was I get 2 columns per period. One with the actuals other with LBE:
Too fixated on the y-axis to show 2 different volumes. But the key was in the x-axis spliting the volume into a type.
(note: you need to have a column in your data that determines if an amount is an actual or an LBE)
Hi @rpinxt ,
Please try to use field parameter, this may be could help you.
For more details, you could read related document: Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn
Thanks for your efforts & time in advance.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
188 | |
111 | |
105 | |
78 | |
71 |