cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BaluChalla
Helper I
Helper I

How to create indicators beside data in power BI

Hi Team,

How to achive bellow requiremnt in power BI.

capture20210115190717757.png

2 ACCEPTED SOLUTIONS

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

yingyinr
Community Support
Community Support

Hi @BaluChalla ,

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

icon conditional formatting.JPG

Best Regards

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

View solution in original post

6 REPLIES 6
yingyinr
Community Support
Community Support

Hi @BaluChalla ,

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

icon conditional formatting.JPG

Best Regards

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

View solution in original post

Vidya_kdd
Frequent Visitor

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

 

amitchandak
Super User IV
Super User IV

@BaluChalla , 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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

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.

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors