Forum Discussion

djensen's avatar
djensen
Frequent Visitor
9 years ago

Conditional formatting on a table with one row

Not sure if this is a glitch, or if anyone else has had this problem. Haven't found a solution posted so far:   I'm building a model for perfomance reports, in which indicators are grouped into 1-r...
General Comment
Need Help
Tips and Tricks
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

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

Daviejoe's avatar
Daviejoe
Memorable Member
7 years ago

Was this ever resolved?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I'm having the same problem with Sep 2019 PowerBI desktop. Any clue?

    • Daviejoe's avatar
      Daviejoe
      Memorable Member
      6 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        I also tried individual objects  (like card or card with states...) which indeed works but it really afects the performance. It doesn't make sense that you can not conditional format a single row table. Will this ever be fixed?