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.
I have my columns chart which displays several security KPIs, all of them are percentages. I want to set a separate trend line on each one of them. Please refer to the following image:
These are 4 KPIs, all saved in the same table. Each percentage represents a value at a given month. Light blue for january, dark blue for february and orange for march.
This is the data im using for this report:
Where:
ENE-24 are the percentages of all kpis for the month of january
FEB-24 are the percentages of all kpis for the month of february
MAR-24 are the percentages of all kpis for the month of march
Indicadores are all the KPI names.
Do I need to create a measure on power bi or in the data sheet (excel) where im extracting the values?
Ideally this is how it should look like:
Thank you in advance
Yes, indeed. Ed's method in the linked blog is the best method I have come across. It's easy to implement and dynamic. Hope it helps
https://www.ehansalytics.com/blog/2019/3/17/create-a-dynamic-date-table-in-power-query
I would consider using small multiples here so that the time [month] can be on the X axis. You will probably want to create a proper date table as well, if you don't have one already.
Hi, thank you for your reply.
Do you have any resources that I can check in order to understand how to create a proper date table for this case?
User | Count |
---|---|
81 | |
76 | |
62 | |
60 | |
48 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |