Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
This bug has been around for a while. I'm thinking about just building the charts in deneb because I can hard code the colors and not worry about BS like this. Does anyone else have any solutions? Is there a way to hard code bar charts in DAX?
Power BI Desktop:
Power BI Service after Publish:
Solved! Go to Solution.
Hi @FloridaMan55051 ,
Depending on which type of visual you are using, the location of where to change the color might be in different locations. But, if you go to the format for the columns in the visual, go to color and select the function option.
Then, you can use the formatting option to choose the color based on the column value:
Proud to be a Datanaut!
Private message me for consulting or training needs.
Hi @FloridaMan55051,
Thank you for reaching out to the Microsoft Fabric Community Forum.
We really apologies for the inconvenience, after reviewing the issue of color of bars change when publishing to power bi service from power bi desktop, here are few steps to may resolve the issue.
Dax Query:
BarColor = SWITCH(
TRUE(),
[Category] = "Category1", "#FF5733",
[Category] = "Category2", "#33FF57",
"#3333FF" // Default color
)
If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
Hi @FloridaMan55051,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi @FloridaMan55051,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.
Hi @FloridaMan55051,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so others can find it easily.
Thankyou.
Hi @FloridaMan55051 ,
Depending on which type of visual you are using, the location of where to change the color might be in different locations. But, if you go to the format for the columns in the visual, go to color and select the function option.
Then, you can use the formatting option to choose the color based on the column value:
Proud to be a Datanaut!
Private message me for consulting or training needs.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
33 | |
26 | |
23 | |
19 | |
15 |
User | Count |
---|---|
49 | |
39 | |
24 | |
20 | |
20 |