search

fredrikheden / summarytable

Summary Table Custom Visual for Power BI
33 stars 17 forks source link

Accounting format #3

Open Toloui opened 5 years ago

Toloui commented 5 years ago

Is there a simple style script to allow negative numbers to display within a bracket and in red similar to DAX Format-> FORMAT([Measure],"#,##0.0;(#,##0.0)"). Thank you Bruce

fredrikheden commented 5 years ago

There is currently no way to make it red based on an expression. However, you can use the expression above to get the parenthesis around the negative number.

andreyluizbuzzi commented 5 years ago

Hey Fred, first of all, thank you! This is the easiest way to summarize tables and create accounting statements. A huge work that will help thousands. I tried to format at the way above, but I got the blank values at the table, is there a reason? When I use the same measure at a any other component it shows properly the values.