Forum Discussion
Conditional formatting on a table with one row
Hi djensen,
Based on my test in Power BI desktop 2.46.4732.721 64-bit (May 2017), if there is only one row in the table visual, as long as the column has set aggregation or put a measure with aggregate function, Conditional Formatting is available.
In your scenario, please use the same desktop version as ours. If issue persists, please share the .pbix file with us if possible.
Best Regards,
Qiuyun Yu
Thanks v-qiuyu-msft!
I do have the May 2017 update, and the problem isn't that I can't set conditional formatting, it's that the conditional formatting doesn't appear once set.
The data is confidential, but let me see if I can replicate the problem with some entered data and share that.
v-qiuyu-msft Here's a sample for you: link
The first page is the example of the table in which the conditional formatting doesn't show up. The second page is the example of the workaround I found, which visually isn't really what I want.
It's a bit simpler than what I'm actually doing, but the basic structure of the databases and the visual is the same.
In reality, there are several tables in the report like the one in the example, with a summary at the top, all with the same format so they read rowwise.
Thanks again!
Hi djensen, v-qiuyu-msft,
Was there ever any resolution on this? I seem to be experiencing the same issue (conditional formatting being settable but not actually appearing on single row tables). I'm using Version: 2.47.4766.801 64-bit (June 2017).
Thanks!
PR
I m having the same problem, is there a solution here?
Was this ever resolved?
I'm having the same problem with Sep 2019 PowerBI desktop. Any clue?
I ended up downloading the Card with States by OKViz customer visual, made an individual card for each total, connected them together so it looked like a one row table.
It was a bit fiddly but it worked for me purposes.
