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)
- Merged Idea (15)
RE: Field Format - Report Wide
I think this is a good idea and will be helpful
RE: Field Format - Report Wide
This is a feature i would also like very much
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)
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.
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
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.
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
RE: Field Format - Report Wide
this was in Qlikview version 9!! and is one of the most requested features by clients
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.
RE: Field Format - Report Wide
It would be great to have conditional formatting allow for color formatting based on TRUE/FALSE results.