Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
hello everyone, I have a chart that I always compare a month and year with the previous one. I need to create a measure that changes the color of the previous year's bar.
Can anybody help me?
thanks
Solved! Go to Solution.
Hi @Spotto
Unfortunately, I cannot understand your test file...
From the attached image I understand that the line issue is not a visual issue, you just need to calculate it the right way.
Something like :
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi @Spotto
You just need to use a combo of line and clustered chart and put your year in a columns legend:
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
@Ritaf1983 tks for your help, but dont work. Only a part worked
BEFORE:
AFTER:
In this chart model that suggested the line does not show by month, but the total or the average only
is there a way to fix this?
I will leave the test file below for you
test.pbix
Hi @Spotto
Unfortunately, I cannot understand your test file...
From the attached image I understand that the line issue is not a visual issue, you just need to calculate it the right way.
Something like :
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
User | Count |
---|---|
106 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |