Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All
Conditional formatting is easy enough to understand, but I am struggling to apply it in the way I want, so need some help.
Here is my basic table. It shows data use over a couple of months, and I want to simply highlight if that particular user has increased or decreased their use each month.
The data comes from 3 seperate data sources whcih will be added to up to a max 6 month period.
But how do i ask conditional formatting to look at the previous column, then format accordingly?!
Any help most welcome.....thanks
Hi @Anonymous
You should be able to use something similar to this:
I created a new Calcultated Column called 'Nov_Higher_Lower' in this column I return a value of -1, 0 or 1 depending on the sign of the number when I subtract Novembers value from Octobers value.
Thanks for the suggestion @Anonymous - appreciate the help, but seems there is an issue reading the October data - which is on a seperate data source?
Used the following:
But the result is:
A single value for column 'Volume (kb)' in table 'Oct2019' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.
User | Count |
---|---|
83 | |
77 | |
72 | |
70 | |
55 |
User | Count |
---|---|
107 | |
98 | |
86 | |
79 | |
67 |