Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi all,
I have a question and please help.
I would like to fill blank cells between two non-blank cells the same colour, when there are two or more blank cells show together.
For example, I would like the two blank cells to show red background colour as their neighbouring cells.
could you help?
Thanks!
Hi @QianHK ,
can you mark the start point with +1 and the end point with -1?
With a running total you could then determine the cells between this values.
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
Hi, thanks for your input.
However, I can't change the numbers in cells. They are counts of certain values. If they are not blank, they are always bigger or equal to 1.
User | Count |
---|---|
123 | |
70 | |
67 | |
58 | |
53 |
User | Count |
---|---|
186 | |
93 | |
67 | |
63 | |
54 |