Forum Discussion
How to get the conditional formatting based on data variance from 2 table columns.
I am trying to conditional formating to show up, down & nutral key if the total count of a vaule of the column in go up or down compare to previous month count of vaule of the column.
As explance shown below.
Thanks
yes, we can do it. just change the number format to show the negetive value enclosed with brackets.
As your main query is solved so you should accept that answer as solution and appreciate the kudos.
29 Replies
Anonymous
can you please provide demo PBIX file?
Hello rubayatyasmin, I manage to create a demo file on my personal device and here is the link for your refrence.
I looking to achive the below requirement if possible:
My expectation is to calculate the variances in the rows by comparing the total counts of the fruits from this week and last week
If the count each rows of fruits in "This Week" table is biger than last week then a up arrow key show show in a new column and the row\count cell should trun red
If the count each rows of fruits in "This Week" table is less than last week then a down arrow key show show in a new column and the row\count cell should trun green
If the count each rows of fruits in "This Week" table is less than last week then a down nutral/equal key show show in a new column and the row\count cell should turn Light yellow
I got your file. I will try this and let you know
rubayatyasmin thanx your response, however inre ply there is no option to attach a file
go to file.io and upload your file.
Hello rubayatyasmin unfortunatly, I dont have the option of file.io option available and my orginization policy prevent me to upload the file to any personal drive like dropbox or OneDrive
rubayatyasmin , you assistance help me to achive the 85% of the requirement however I still have one challenge this the substaction. If use this formula
Variance of fruit count from LW = [Fruit Count TW] - [Fruit Count LW] then we are getting value in "-". e.g. 6-3 should be 3 not -3 somthing like that...Brother see the logic plz. The measure is subtracting this week - Last week. so 3-6 =-3
Appreciate some kudos.
rubayatyasmin thanks for your extense help and I really appriciate it... Is there a way we can remove the netgative marking from the calculation... Just curious because we have the conditional formating icon to show if the number is up or down.