Reproducable bug: Calculation groups break conditional formatting GUI

[Anonymous]

Creating any calculation group in a Power BI report seem to permanently break the ability to add or change any conditional formatting on all current and new visuals. This includes things like conditional background, font color and icons in tables/matrices. Other examples being conditional titles on visuals, conditional axis ranges, data labels and colors in graphs.

Removing the calculation group(s) does not fix the issue.

Version: 2.129.905.0 64-bit (May 2024)

How to reproduce:

1. Open Power BI Desktop and create a blank report

2. Add a simple one column table with 2 text rows. Example: {"a","b"}

3. Pull data field onto canvas, which will create a table visual.

4. Add a conditional title to the visual. This will default to the first value of the one column table. Press ok.

5. Add a calculation group. This will create a single calculation item with the default: "Calculation item = SELECTEDMEASURE()"

6. Now go back to the the table visual and try to adjust the conditional title to last value. - This will not work.

7. Remove the conditional title and try to add it again. - This will not work.

8. Remove the created calculation group.

9. Repeat step 6 & 7. - These will still not work.

10. Create a new visual and try step 4. - This will not work.

10. The Power BI report is now bugged and will not have a functioning GUI for conditional formatting.

These things does not fix it:

- Disabling all preview features

- Removing all data and pages

- Saving it as .pbip, .pbit and .pbix

- Opening the report on a separate workstation

[Anonymous]

I managed to identify the culprit:

Disabling this after removing the calculation group will bring the report back to normal.

I can see the reason why this would not allow conditional formatting without using explicit measures, but it should really be communicated better in the UI. The discourage flag will not break any existing formatting logic using implicit values, which only causes more confusion.

I would recommed adding additional context in the conditional formatting UI, when the discourage flag is present, instead of the current way of just displaying a constant red border around the field selection.

[foodd]

Hello @Anonymous , interesting feedback which I suspect would stand on its own as a new issue, if you would be gracious to post one. Please do include a URL to this issue in the body. Thank you!

[Anonymous]

Hi  @Anonymous ,

Thanks for your feedback! For the feature improvements, you may vote the idea and comment here to improve this feature. It is the right place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Best Regards,
Community Support Team _ Caitlyn