Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi there!
when making a chart using a double X axis with labels and a date hierarchy, there are values that fall outside off the dates for whatever reason and as such, cannot be plotted to the axis. This results into a (Blank) category.
Now i want to simply remove this label, but keep the values.
I tried 'hiding' it with conditional formatting, but that doesn't work.
Any suggestions would be welcome!
Hi @decarsul ,
If you're referring to the x-axis label, there is a conditinoal formatting option but that doesn't seem to be working. I am expecting green for 202401 but they all return blue
Proud to be a Super User!
exactly, it is weird. why would blank show as a value while its a nill?
Hope someone has a solution
If the conditional formatting works fine, you should be able to render a text invisible by making it fully transparent using RGBA(0,0,0,0) in the conditional formatting measure (it will return 100% transparency as long as the 4th number is zero, the other zeroes can be anywhere from 0 to 255).
Proud to be a Super User!
That is the thing tho. it doesnt.
I applied conditional formatting to blank, null or 0, and it doesn't apply conditional formatting to the label 'Blank'.
The conditional formatting on X-axis label or any other axis labels doesnt work. I dont even know why it is there.
Proud to be a Super User!
so.... bug? 😄
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
84 | |
66 | |
49 |
User | Count |
---|---|
127 | |
109 | |
93 | |
70 | |
67 |