Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
lgoggs
New Member

Missing fx clustered bar chart colour?

Hi, 

 

Forgive the stupid question, but I feel I have wasted too much time trying to solve something that should be straight forward. I am attempting to apply conditional formatting to clustered bar chart colours, based on a filter selection. All the solutions I have found point to applying rules in the 'fx' option next to the colour dropdown for that particular series. 

 

However, I cannot seem to find that next to my colour drop down. It's just a drop down to select a colour for that series with no additional options to apply conditional formatting (Please find screenshot below): 

 

clustered_bar_settings_example.PNG

 

I feel like I'm missing something very obvious and apologies if so, but any help would be greatly appreciated. 

 

Best wishes,

 

Luke

1 ACCEPTED SOLUTION

Hello @lgoggs ,

 

yes when it's more than one values in the value field it won't show as well.

 

if you try to have one field in the value section then it will show.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




View solution in original post

5 REPLIES 5
Alex87
Solution Sage
Solution Sage

Hello,

Try to remove the legend from the graph. You should be able to see the fx for color

lgoggs
New Member

Thank you @Idrissshatila, I did wonder this myself, but when I select 'All', I get even less options (As shown below):

 

clustered_bar_colour_all.PNG

 

I do wonder is it the way I've got my data setup? It's essentially a text category on the y-axis then 3 series of number values on the x-axis. 

 

Best wishes,

 

Luke

Hello @lgoggs ,

 

yes when it's more than one values in the value field it won't show as well.

 

if you try to have one field in the value section then it will show.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Thank you @Idrissshatila ! That seems to have sorted it. It looks as though because I had 3 data points added to the x-axis it was not allowing me to apply any conditioning formatting on the colour. I've removed and just had one and it's now providing the option. 

 

The challenge is I do need all 3 data points on the same chart to change colour based on a filter selection. I will explore potentially doing this by creating a 'Measure' might hopefully work. 

 

Thank you again!

 

Best wishes, 

 

Luke

Idrissshatila
Super User
Super User

Hello @lgoggs ,

 

the fx only shows when you're showing All categories not when selecting a specific category as in your case you selected 2023.

Idrissshatila_0-1715063049326.png

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors