Clustered and stacked column charts BUGS

[Analitika]

How to put rules for values?

[StefanoGrimaldi]

dunno, couldnt find the pbix file on the folder you shared.

[StefanoGrimaldi]

ok, try doing this them using DAX 

step 1: 

Quantity = sum(Salestable[Quantity])

Step 2:

Highest / Lowest Value (subcategory) =

var highestvalue = MAXX(ALLSELECTED(Salestable[Sub Category]),[Quantity])

var lowestvalue = MINX(ALLSELECTED(Salestable[Sub Category]]),[Quantity])

return

IF([Quantity]= highestvalue,”#73B761″,

IF([Quantity]= lowestvalue,”#DB271C”)

you can change around the syntaxys to match your case but this should work. 

exambple result:

[Analitika]

It is ok, but why this bug appears? 

[Icey · Accepted solution]

Hi @Analitika ,

That is caused by "Legend". If the colors of the columns have been defined by "Legend", they can't change according to custom rules at the same time.

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[StefanoGrimaldi]

hey, 

first open the visual format area and click to off the showw all on data colos option as below: 

them click on the formula botton on it and configure with the parameters you want it to color your data and rules:

formatting for rules on bar chart do have the limitation that you must enter the rules as a range for what you looking for. 

now if you use it as a table you will have more formatting options: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting 

[Analitika]

@StefanoGrimaldi 

I dont have such options, everything up to date

[StefanoGrimaldi]

Strange, you  say you have power BI desktop up to date to the last version? 

cant replicate the error Im using that same chart type and its appearing for me. 

can you share the PBIx file with only the visual and some garbage data to see if can replicate the error with it?

[Analitika]

@StefanoGrimaldi 

i know what new chart will fix that but i dont want to recreate more whan 100 visuals

https://filebin.net/nyisjovl15hrrade