Skip to main content

Power BI

Under Review

Field Format - Report Wide

Vote (3243) Share
Collin Quiring's profile image

Collin Quiring on 22 Oct 2019 03:40:22

We often have columns or measures that we want to be formatted the same in EVERY report tab in EVERY visual the same way. There is no universal method to format a measure in every visual in a report. We have to go into each visual on each report tab and do the exact same field formatting (colors, etc.) in each visual. We would like there to be a Universal option.

And, you know what will come next? :-) No doubt, somebody will want the formatting to be report wide EXCEPT for one single visual somewhere. Is that possible too?

Comments (118)
Collin Quiring's profile image Profile Picture

Brad Rose on 05 Jul 2020 23:23:59

RE: Field Format - Report Wide

I think this is a good idea and will be helpful

Collin Quiring's profile image Profile Picture

joost oosterbaan on 05 Jul 2020 23:23:54

RE: Field Format - Report Wide

This is a feature i would also like very much

Collin Quiring's profile image Profile Picture

Flip on 05 Jul 2020 23:20:38

RE: Field Format - Report Wide

The current possibilities of formatting in Power BI are too basic.

Why can I not color a whole line of my table regarding the text of a certain column in 2018 ?

(a matrix that I cannot rotate by the way)

Collin Quiring's profile image Profile Picture

David Southerland on 05 Jul 2020 23:19:18

RE: Field Format - Report Wide

I don't even need to be able to set the colors, I just want visualizations on one dashboard to use the same color for the same value in a common field.

Collin Quiring's profile image Profile Picture

KRIS WILLISON on 05 Jul 2020 23:19:16

RE: Field Format - Report Wide

I was most disappointed yesterday to find that I could only use conditional formatting on a field that has had an aggregate function applied.
I could use AVERAGE in the one column I need, but then I end up with decimal places I don't want to see. Either need
1) conditional formatting similar to EXCEL
2) ability to specify the output format for numbers in a table
3) ability to turn off totals line for a given field in a table

Collin Quiring's profile image Profile Picture

Robert Houghton on 05 Jul 2020 23:18:26

RE: Field Format - Report Wide

I cant believe this request is still going. I've just completed a large Power BI project and the lack of decent conditional formatting has held us back massively. In fact, if it weren't for the fact we get access to Power BI via our corporate E5 licence we'd probably have been off to Tableau or Qlik because of this limitation. As a minimum Power BI desperately needs conditional formatting on text and on the totals in tables.

Collin Quiring's profile image Profile Picture

Steven Kienle on 05 Jul 2020 23:16:52

RE: Field Format - Report Wide

I agree this should be available through out Power BI, including:

* available for market place visualization developers to use
* ALL value types, not just numeric

Collin Quiring's profile image Profile Picture

bb on 05 Jul 2020 23:15:39

RE: Field Format - Report Wide

this was in Qlikview version 9!! and is one of the most requested features by clients

Collin Quiring's profile image Profile Picture

JaniL on 05 Jul 2020 23:12:40

RE: Field Format - Report Wide

You should be able to write a proper expression to control the format. In fact you should be able to write an expression behind every single property, just like in SSRS.

Collin Quiring's profile image Profile Picture

B.M. on 05 Jul 2020 23:10:34

RE: Field Format - Report Wide

It would be great to have conditional formatting allow for color formatting based on TRUE/FALSE results.

Merged Idea (15)