PowerBi DAX Background colour: Conditonal formatting for dynamic measures with same total
Hi frens, I was wondering if someone has ever done Dynamic conditional formatting based on dynamic values of measures. I have sales data for the different cities and I want dynamic color changes based on total sales amount. To be more specific what I am looking for is upon changing city, the first highest sale amount should stay Red, the second highest should stay blue, the third highest should stay yellow and the least product should stay orange. Your help would be much appreciated.
