Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

0

Reproducable bug: Calculation groups break conditional formatting GUI

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

 

Status: Delivered

Hi  @MHW ,

 

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

Comments
MHW
Regular Visitor

I managed to identify the culprit:

MHW_0-1718715464218.png

 

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
Super User

Hello @MHW , 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!

v-xiaoyan-msft
Community Support
Status changed to: Delivered

Hi  @MHW ,

 

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