How to create indicators beside data in power BI

[Anonymous]

Hi Team,

How to achive bellow requiremnt in power BI.

[amitchandak · Accepted solution]

@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]

[Anonymous · Accepted solution]

Hi @Anonymous ,

I created a sample pbix file(see attachment) for you, please check whether that is what you want.

Best Regards

[Vidya_kdd]

We can do conditional formating (icon) and define the rules and choose an icon for each rule.

[amitchandak]

@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

[Anonymous]

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.

[Vidya_kdd]

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.

[amitchandak · Accepted solution]

@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]