Conditional formatting

Question

Hey!Im having some issues with using the "Conditional Column" module, for creating groups from a column containing more than 500 different values.&nbsp;Right now the code for this looks like " else if [Konto] = "20230" then "Eksterne omkostning" else if [Konto] = "20235" then "Eksterne omkostning" else if [Konto] = "20240"" etc.&nbsp;&nbsp;But I cant figure out how to make it into a shorter and easier to manage code.&nbsp;&nbsp;&nbsp;

az38 · Answer

Hi&nbsp;Anonymous&nbsp;
use switch() in DAX,&nbsp;in your case
Column = SWITCH([Konto],
"20230", "Eksterne omkostning", 
"20235", "Eksterne omkostning" ,
"Other")

&nbsp;solutions for power query will not be very much beautiful 🙂

v-lili6-msft · Answer

Hello @JessVinsteen
Try this logic:
Column?

SWITCH(TRUE(),
[Account]&gt;1&amp;&amp;[Account]&lt;-5, "a group",
[Account] &gt; 6 &amp; &amp; [Account] &lt; 8, "Other Group",
([Account]&gt;-13&amp;&amp;[Account]&lt;-15)-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ([Account]&gt;-18&amp;&amp;[Account]&lt;-20), "third group"
)

Best regards
Lin

greg_deckler · Answer

Create a second table in Excel or something with the translations between the numbers and the text values. Use a Merge query.

anonymous · Answer

So if I want to have 10 different values in one group I could do it like this:&nbsp;Column = Switch([Konto]),"20230", "20030"; "Ekstern omkostning";&nbsp;&nbsp;&nbsp;

v-lili6-msft · Answer

hi&nbsp;&nbsp;Anonymous&nbsp;
Yes, you could IF() or&nbsp;Switch() Function to get it, see more details by this blog:
https://powerpivotpro.com/2012/06/dax-making-the-case-for-switch/
&nbsp;
Regards,
Lin

Forum Discussion

Conditional formatting - IF else - for more than 500 different values

6 Replies

Related content

Conditional Formatting using DAX

Conditional formatting for difference between bars?

Conditional Formatting

Matrix Row Conditional Formatting