topic Re: Column chart formatting based on parameter in DAX Commands and Tips

Column chart formatting based on parameter

gumis_rulez — Mon, 27 May 2024 12:37:57 GMT

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?

Re: Column chart formatting based on parameter

xifeng_L — Mon, 27 May 2024 15:35:58 GMT

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~

Re: Column chart formatting based on parameter

gumis_rulez — Mon, 27 May 2024 15:51:46 GMT

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

Re: Column chart formatting based on parameter

gumis_rulez — Mon, 27 May 2024 15:56:12 GMT

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

Re: Column chart formatting based on parameter

xifeng_L — Mon, 27 May 2024 16:26:26 GMT

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~

Re: Column chart formatting based on parameter

gumis_rulez — Mon, 27 May 2024 16:35:54 GMT

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?

Re: Column chart formatting based on parameter

xifeng_L — Mon, 27 May 2024 16:59:46 GMT

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

Demo - project_one_issue.pbix