Column chart formatting based on parameter

[gumis_rulez]

Hi,

I am using dax function to create dynamically table with number of clients in each segment. The function is as follows:

All Customers Count =

Var CustomerOrders =

    SUMMARIZE(

        Orders,

        Orders[CompanyName],

        "Orders Count", DISTINCTCOUNT(Orders[OrderID])

    )

Return

    COUNTROWS(FILTER(CustomerOrders, [Orders Count]='Customer Segmentation'[Customer Segmentation Value]))

Would like to create a bar graph as below but formatted in two colors:

-- customers below selected value orange

-- customes above selected value dark blue

Any hints how to resolve this?

[xifeng_L]

Hi @gumis_rulez ,

You need to create a measure and use it to the conditional formatting of bar color, can refer to below demo.

Color = 
VAR SelectedNum = SELECTEDVALUE('Parameter'[Parameter])
VAR CurCustCount = [All Customers Count]
RETURN
IF(CurCustCount<SelectedNum,"#e96b30","#118dff")

//IF(CurCustCount<SelectedNum,"orange","blue")

Demo - Column chart formatting based on parameter.pbix

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~

[gumis_rulez]

I have followed your way and it seems it is not working. I am attaching my file.

https://drive.google.com/file/d/1gtJZnGAkEPzXYvMn77hH5eVAYzaaCMG3/view?usp=sharing 

[gumis_rulez]

It should change color based on the customer segmentation; below 7 as on this picture orange.

[xifeng_L]

@gumis_rulez 

You previously blocked the slicer's filtering of the visuals, resulting in slicer-selected values not being passed.

You need to create another parameter table and apply it to the slicer. Pls refer to below demo.

Demo - project_one_issue.pbix

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~

[gumis_rulez]

Very interesting solution. For sure will use someday.

For this project the goal is to create conditional formating based on x-axis customer segmentation. If parameter = 4 then the graph should look as follows:

In your solution the conditional formating works based on the values for each of 20 segments. In the desired one, no matter the value - parameter formats the segments. Is it something which can be done?

[xifeng_L · Accepted solution]

Sure, only a slight modification of the expression is required, sorry for misunderstanding your needs before.

Demo - project_one_issue.pbix