Forum Discussion

rashidanwar's avatar
rashidanwar
Icon for Advocate II rankAdvocate II
2 years ago
Solved

Dynamic Categorization Based on Value in a Stacked Column Chart

Hi Everyone Challenge: I created a stacked column chart visualizing monthly order counts by city. Each column represents total orders for a month, broken down by individual cities in the legend....
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi rashidanwar ,

    Below is my table:

    The following DAX might work for you:

    City1 = IF('Table'[Data] < 5,"Other",'Table'[City]) 

    The final output is shown in the following figure:

    Best Regards,

    Xianda Tang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.