group the data based on colors ( if you open the below link you can download pbix file)

[pasupathi]

Dear Helpers

when you download and open the file you will see some color formattig like "yellow","red".
i need to group by yellow color
i need to group by red color
after grouping i need to show both in charts   

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

[v-yalanwu-msft · Accepted solution]

Hi, @pasupathi ,

You could add a column by dax.

Group = IF([gap]<=0,"Group1","Group2")

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[otravers]

In Excel you can easily group rows by color but I haven't seen any similar functionality in Power BI. The way I'd approach this in Power BI is to base color-coding on a DAX measure that I would also use for grouping.

[pasupathi]

 hi otravers
i didnt understand.the answer is yes or no 
regards
Dilip