Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm wanting to show a simple line chart that shows the values for each user month after month. Along with those values I want to have a line that shows the average so we can easily see who is over/under performing. My issue is that if I put the names column in the legend space I can't place my average calculation and if I place my average calculation in the values or secondary values space I can't use the legend anymore. Is there a way around this?
In the picture below you can see the visual with the legend in place but the calculated column "Average Value" is not able to go in the values or secondary values space.
I'm guessing the issue is that the average calculation doesn't have an associated "Name" for the legend but hoping there's a solution. Thank you!
Solved! Go to Solution.
Hi @GunnerJ ,
The visual with legend field does not support adding multiple values at present. Please try to create multiple measures.
a = CALCULATE(SUM('Table'[value]),'Table'[Type]="a")
b = CALCULATE(SUM('Table'[value]),'Table'[Type]="b")
c = CALCULATE(SUM('Table'[value]),'Table'[Type]="c")
average_ = AVERAGE('Table'[value])
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @GunnerJ ,
The visual with legend field does not support adding multiple values at present. Please try to create multiple measures.
a = CALCULATE(SUM('Table'[value]),'Table'[Type]="a")
b = CALCULATE(SUM('Table'[value]),'Table'[Type]="b")
c = CALCULATE(SUM('Table'[value]),'Table'[Type]="c")
average_ = AVERAGE('Table'[value])
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @GunnerJ ,
May be try using other visual like Line and Clustered Column chart and then use SMALL MULTIPLES. Somehting like below:
Thanks,
Pragati
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |