Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hit Reply to tell us what you think about the new format pane so we can continue to improve.
For example:
Thanks,
-Power BI team
To read more about the feature see the announcement in the Power BI Product Blog
I am relatively new to PowerBI, but I have built out a few reports in one file. The issue I am having is each tab is going to represent a specifc metric, and we are tracking data accross our facilities, but some metrics only apply to a few facilities. I would like each facility to be represented by the same color accross metrics. When I apply a theme it just assigns colors in order so in many cases the colors don't align accross metrics. I found some older posts/articles that there used to be a Data Colors pane in the Format Pane that allowed for conditional formatting. I was able to turn off the current feature and see the Data Colors pane, but it did not have the conditional formatting option available. Is there a way to do this is the latest version?
Can you share a screenshot of which visual type (is it a matrix/line/bar etc.? ) you're using and the "data colors pane" you're referring to?
Here is the 'Data Colors' section with the New Format Pane feature turned off.
When the feature is turned on, the colors show up under Columns for this specific visual. I am primarily working with column and line charts.
In a few articles I've seen, there is reference to the fx (conditional formatting) button. I do not see this in either instance, so I'm not sure if it is a result of specific visuals or if I need to create a DAX formula first, like is done in this link.
Set Power BI Data Color: All Visuals to Follow Same Color for the Same Data Point - RADACAD
Thank you,
Andrea
It depends on your data, we currently don't support conditional formatting on charts with legends on them, such as when you put a field into the Legend field well or when you put multiple measures into value field wells. From your screenshots here it does look like you have a legend in your visual so that is why you don't see the fx button.
Great to know. Thank you for your response and explanation. Do you know if there is a way to assign colors based on a specific value (i.e. facility), while keeping the legend, that would be consistent accross reports when where the number of facilities represented could vary. For instance, we have some metrics that include 3 facilities and others include 5 or 6. We just want to ensure the facility color stays the same accross metrics and visuals, regardless of how many facilities are displayed. Or is this something that could be considered for a future PowerBI feature?
*I tested removing the legend and I do see the conditional formatting appears for column charts, but not line charts.
Thanks again,
Andrea
If the color is automatically set through the theme, it should maintain the same color across pages in the report. So if facility is red in one visual, it should be red in another. Of course you can explicitly set the colors to be the same but that is pretty manual work. We're actually working on a way to set colors by value at the report level, this is still in planning and development.
Thanks, Rosie. Glad to hear this is in the works. The problem we had with the theme is that we don't always have the same facilities in every report so if theme color 1 is dark blue, whatever facility is listed first would be dark blue. Sounds like the project in the works might solve this issue for us down the road though. 🙂
Don't expand the first category or also include in settings the option to keep everything always collapsed so we just open the category we need. We don't always are searching for the first category so there is no need to have it always expanded.
Thank you.
If you're looking to fix obvious gaps between tables and matrices, below is another which would be good to get sorted.
I often show a combination of the two on my reports and it is impossible to make them look similar. On the left is a table which has an outline option for totals at the bottom. The same option is not there for matrix on the right so looks inconsistent when the two are next to one another on a page. @RosieL would you be able to raise a feature request for this too? TIA
Thanks for sharing. This is actually already on our backlog!
In general, I like the new format pane. However, with the April release, we have a client whose Log (not Linear) x-axis scales in Scatter plots were changed to Linear. Oddly, this didn't happen to the y-axis (which was also Log). This really frustrated them and has made them second-guess having the automatic updates version of Power BI installed.
Thank you for reporting. This is a severe one, we found the issue and will be getting a fix in ASAP.
Great to hear - how will I know when that update has been made?
Hi Zack - this has been fixed for the latest May build available from the App store. This is also fixed for the upcoming June release. Thanks again for reporting!
I can reply here as well as call it out in the next blog post.
For custom themes what are the new options.
For example being able to define the Column/Row subtotals and Column/Row grand total.
Thanks for this callout. We are in the process of updating the customer facing docs on the new additions. Please stay tuned.
Hi,
since I didn't find anything to this topic I entered a new question.
How can I align / syncronise the y-axis on the line or bar-line diagram? I can't find any setting in the new format pane. I would think this is an essential feature.
Thank you.
BR
Daniel
Hi, are you referring to showing/hiding and customizing the range for the secondary y-axis or a different setting?
Hi,
Yes, exactly. I have two Y-Axis values and want to sync e.g. the 0 value. This was possible in the old pane. But I couldn't find this setting in the new format pane.
Thx. BR
I too was looking for this the other day. Wasnt also able to sync two axes together either.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
86 | |
82 | |
70 | |
49 |
User | Count |
---|---|
143 | |
123 | |
107 | |
61 | |
55 |