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.
Dear community,
I would like to format the background colour of a matrix based on a lower and an upper limit that is specified per combination.
For every combination there is a first sticking day and a last sticking day specified, and all days that fall below the lower limit or above the upper limit should be coloured red.
Then I will insert the amounts by a measure which will show the "actuals" per day of the week. Preferably this happens within those same coloured cells.
In below screenshot i've tried to demonstrate this for the first 4 combinations. The cells of the column values "Day no." should be coloured for the lower limit and upper limit that is specified per combination by "MD_FirstStickingDays" and "MD_LastStickingDays" respectively.
Thanks a lot in advance!
Hi @jrmemelink ,
Pls refer the below link, and check if it is helpful ,if question still not solved ,pls share a sample data and expected output result.
Best Regards
Lucien
Hi @v-luwang-msft,
This is not it unfortunately.
I added the desired outcome in my post. Im not familiar with uploading data through this community, so i created a link through wetransfer: https://we.tl/t-k7w5WOx08e
(Important to note is that column numbers 1-7 are given by another data table which is connected to the data through Column MD_LastStickingDay
I think the way how to do this is by creating a measure for each Column if it is lower than or equal to MD_LastStickingDay, but have not figured out how to do so. Next step (i think) would be to do conditional formatting based on that measure.
Any help is welcome!
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 |
---|---|
107 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |