Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
@Anonymous , with help from a date tbale have measure like this and create a diff measure and do formatting on that
This Day = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])))
Last Day = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])-1))
Last Day = CALCULATE(sum('order'[Qty]), previousday('Date'[Date]))
diff = [This day] -[Last day]
Hi @Anonymous ,
I created a sample pbix file(see attachment) for you, please check whether that is what you want.
Best Regards
Hi @Anonymous ,
I created a sample pbix file(see attachment) for you, please check whether that is what you want.
Best Regards
We can do conditional formating (icon) and define the rules and choose an icon for each rule.
@Anonymous , You can do Icon formatting. Or Unichar and color formatting
https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692
More on unichar -https://www.youtube.com/watch?v=veCtfP8IhbI
Thanks for quick response.
Is it possible to create icon based on previous day values.
Example :
Yesterday - 5000 -- stright arrow
Today - 6000 -- cross above arror : indicate data got increase
Note: Please once again refer my screenshot and please guide me.
you calculate the value for yesterday date (A)and calculate value for today's date(B). Find the difference (B-A). Aplly conditional formatting on the difference.
@Anonymous , with help from a date tbale have measure like this and create a diff measure and do formatting on that
This Day = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])))
Last Day = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])-1))
Last Day = CALCULATE(sum('order'[Qty]), previousday('Date'[Date]))
diff = [This day] -[Last day]
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |