Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hey community,
it is my first request for help. Since being very new to Power Bi I was trying to help myself and searched for solutions in the community. But unfortuetly I haven't found any solution yet.
Objective:
I want to show lines for each production year (legend).
Values of the lines are running total of parts [Parts] (y-axis) over month in service [MIS] (x-axis).
I used an addtional measure as values
Problem:
It works without adding production year to legend. Then I have one line combining all production years. If I add it to legend, I get multiple lines which increase and drop 😞
I tried to check "show items with no data" - it doesn't help.
Thank you
Chris
Do you have a seperate date table that you are using to populate the years or are you populating the years from the fact table?
A good rule of thumb is to create measures and use value from the fact table and to populate rows and axis from the lookup/dimension table.
Proud to be a Super User!
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |