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.
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.
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 |
---|---|
109 | |
105 | |
88 | |
75 | |
67 |
User | Count |
---|---|
123 | |
112 | |
96 | |
82 | |
72 |