Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good day,
I have created a report and some tables with a conditional formatting. With one table, I had the option to select wheter it is a number or a percentage.
However, I have tried to create a new table with its conditional formatting. It didnt appear the option to select number and it wasnt working. I also tried with other reports and I think this conditional formatting is not working.
Do you know what is happening? I hope you can help me.
Thank you very much
Solved! Go to Solution.
I would suggest you create a new calculate column using dax below and do the summarization operation on the new column:
New Column =
IF ( Table[Boolean] = TRUE (), 1, 0 )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I would suggest you create a new calculate column using dax below and do the summarization operation on the new column:
New Column =
IF ( Table[Boolean] = TRUE (), 1, 0 )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Create a measure that return color and use like
https://community.powerbi.com/t5/Desktop/Conditional-Formatting-not-working/m-p/827603
Hello,
But I need to put a background in the field. It could be possible?
What @amitchandak suggested could work...sample code from something I worked on
ProgramEnrollmentStatusColor =
SWITCH(
ProgramEnrollments[ProgramEnrollmentStatus],
"Active", "#3FB3E2",
"Completed", "#47C0BA",
"Expired", "#E5417A",
"Abandoned", "#FCD722",
BLANK()
)
Substitute the status with your values and you can Google for the hex codes for the colors you want.
After you create the column/measure for the color, in conditional formatting you want to format by field value.
Data type issue? The second one has values of 0 and 1...is that a Boolean field?
Hello,
It could be a boolean, however it is 0 or 1, and I need the sumaration.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |