Forum Discussion
Data visualization project
Hi dwalt0117,
Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.
Thank you.
You are currently summing the values of the columns, you should either create a measure or group those columns
but
Please clarify better what you want to do in words first so we can understand each other
and what the following sentence means (provide examples of the issue)
but no matter how I pivot the table, it changes how the metrics are plotted.
Thanks
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
Moving the order of the metrics in the Secondary-Y axis causes at least one other metric to fall flat and not represent the individual values, if this makes sense. I'm not sure if I'm even using the correct terms here, as I said, I'm very new to this! Somehow, I managed to fix it, and I think I have it where I want it; however, it looks very sloppy. What I did was attempt to sort by Patient ID, which led to me having to create a column to pad the patient ID to 3 numeric values because CSV dropped the leading zeros in the original data file (Patient ID was originally 1-500, which was enabling me from sorting ascending or descending), when I went back to the chart, it was representing the lines correctly, despite them still being "sum" values. Here's an updated visual.
