Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, I'm trying to represent in a graphic a line value that shows the percentage of the sum of one category divided by another, my X axis is divided by Date, my series are the 2 values of the category column, and the values for the graphic are the Sum of the production. here's the graphic:
for example in 2020 july the line values should be around 7503 / 24864 = 30.17%, and so on for the next months.
If anyone can help me with this, I'll be very much appreciatte. Thanks!!!
Hi @Midguel ,
Attached demo file.
Result:
DAX code for line measure:
User | Count |
---|---|
42 | |
26 | |
21 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |