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 Community,
Does any body know why the conditional formating not working when you have only one row in your table? Appricate your responce.
Regards,
Shahin
Solved! Go to Solution.
Hi,
According to your description, I think that any table which doesn't have a grouping displayed as a single row doesn't support conditional formatting.
Reference:
And I have a workaround for your problem, so I create a table to test:
please take following steps:
1)Create a measure to minus [Actual] and Budget:
Measure = SUM('Table'[Actual])-SUM('Table'[Budget])
2)Create a measure to define font format and apply it to above measure:
Format = SWITCH(true,[Measure]>0,"#FF0000",[Measure]<0,"#008000")
And it shows:
3)Add a column and change it not summarize:
When you remove [Department], it shows:
if you do not want to display the blank column, you can turn off ‘Word wrap’ function in visual format/column headers:
And it shows:
Here is my test pbix file:
Best Regards,
Giotto Zhi
Hi,
According to your description, I think that any table which doesn't have a grouping displayed as a single row doesn't support conditional formatting.
Reference:
And I have a workaround for your problem, so I create a table to test:
please take following steps:
1)Create a measure to minus [Actual] and Budget:
Measure = SUM('Table'[Actual])-SUM('Table'[Budget])
2)Create a measure to define font format and apply it to above measure:
Format = SWITCH(true,[Measure]>0,"#FF0000",[Measure]<0,"#008000")
And it shows:
3)Add a column and change it not summarize:
When you remove [Department], it shows:
if you do not want to display the blank column, you can turn off ‘Word wrap’ function in visual format/column headers:
And it shows:
Here is my test pbix file:
Best Regards,
Giotto Zhi
Hi @Shahin ,
Could you please show your sample data or screenshaot or measure of your report?
Because it always works in my report.
Aiolos Zhao
Proud to be a Super User!
Hi @AiolosZhao
On the left I have my measure against department which works pefectly fine but as soon as I remove the department from the table (table on the right) the conditional fromating stops working.
Thanks
Hi @Shahin ,
Are you using a Field value to do the conditional formatting?
If yes, could you please share your Field value measure?
Aiolos Zhao
Proud to be a Super User!
No, I m using the rules . I tried the Filed Value and got the same result.
SWITCH(TRUE()
,[F A Lab Rev]- [F B Lab Rev] < 0,"#FF0000"
,[F A Lab Rev]- [F B Lab Rev] > 0 ,"#008000"
)
@Shahin ,
I assume the [F A Lab Rev] and [F B Lab Rev] are actual and budget, and it works for the first 2 rows.
It also doesn't work for the third row, but the "#008000" is green color I think, but it's black in your left table.
Aiolos Zhao
Proud to be a Super User!
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |