Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello Community,
I hope you are doing well, you and your families. I have a question, I found the beginnings of answers on this forum but I can't seem to do what I would like. Here is the background: I have two parameters: "Year analyzed" and "Comparison Year". As you can see from the diagram, the year of comparison is always the same and the other changes a color for the week, another for Saturday and the other Sunday.
Thank you for your help
Solved! Go to Solution.
Hello
I dont find solution with a measure.
Anytime I put a legend to see year, its not working anymore.
With the measure and if I put the paramter table as legend and not the Year, its working.
Thank you for your help, youre awesome
Hi @Milozebre ,
Is this what you want?
If the visual is Clustered column chart, you can't set conditional formating on it. Conditional formatting applies only to the values of Table or Matrix visuals.
So, I'm afraid what you want is not possible currently.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello @Icey ,
I can put some contionnal formating on clustered column chart as you see with this measure (see image) :
Hello
I dont find solution with a measure.
Anytime I put a legend to see year, its not working anymore.
With the measure and if I put the paramter table as legend and not the Year, its working.
Thank you for your help, youre awesome
Hello,
I try this measure :
Check color by rule and color by value
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting
Few examples of measure that can used in color by values after selecting fields
Color Date = if(FIRSTNONBLANK('Date'[date],TODAY()) <today(),"lightgreen","red")
Color sales = if(AVERAGE(Sales[Sales Amount])<170,"green","red")
Color Year = if(FIRSTNONBLANK('Date'[Year],2014) <=2016,"lightgreen",if(FIRSTNONBLANK('Date'[Year],2014)>2018,"red","yellow"))
Hello @amitchandak
Thank you for the reply
I create a measure like this :
Combine with max year and create one or more combinations
If(max(Table[year]) =2007,
SWITCH(
SELECTEDVALUE(Comptage[jour]);
"JOB";"#009AA6";
"Samedi";"#A1006B";
"Dimanche";"#659200"),
///change the color for another year
SWITCH(
SELECTEDVALUE(Comptage[jour]);
"JOB";"#009AA6";
"Samedi";"#A1006B";
"Dimanche";"#659200") )
Hi @Milozebre
You can add a day of the week number column to your date dimension, later use it for conditional formating of you chart as below
Hello @Mariusz
thank you for the reply.
As you can see on the chart above, what is gray is the year of analysis ex 2018
and in blue, the year of comparison. Gray can't change.
The analysis year which is a parameter must always be gray and the year of comparison on the basis of days must have the predefined colors.
I wanted to make measurements with Swhith but I don't know how to incorporate the parameters:
Year analyze = "Gray"
If day = "Job" with Year comparison; "Red"
for example
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
86 | |
82 | |
70 | |
49 |
User | Count |
---|---|
143 | |
123 | |
107 | |
61 | |
55 |