Forum Discussion
Chart Formatting with Slicer
In my report I have several clustered column charts with Cases, Sales $, Lbs etc. When using slicer to select vendors, some vendors may have thousands and some may have millions of units. Is there a way to have the chart go to select formatting with vendors if they're in millions to display certain way, and others that have numbers in thousands to display in thousands?
Hi, oktrey
PowerBI's built-in charts currently do not allow you to dynamically style your custom units.
You can consider refer to this thread to create a R visaul chart.
Bar-chart-with-thousands-ending-in-K-and-millions-in-M
You can also create a measure to be used in your tooltip, using a threshold of 1M and return one of two formats using the FORMAT measure.
New Measure = VAR variableA = SUM ( 'table'[column] ) RETURN SWITCH ( TRUE (), variableA <= 1000000, FORMAT ( variableA, "###k" ), variableA >= 1000000, FORMAT ( variableA, "###.0M" ) )Best Regards,
Community Support Team _ Eason
1 Reply
Hi, oktrey
PowerBI's built-in charts currently do not allow you to dynamically style your custom units.
You can consider refer to this thread to create a R visaul chart.
Bar-chart-with-thousands-ending-in-K-and-millions-in-M
You can also create a measure to be used in your tooltip, using a threshold of 1M and return one of two formats using the FORMAT measure.
New Measure = VAR variableA = SUM ( 'table'[column] ) RETURN SWITCH ( TRUE (), variableA <= 1000000, FORMAT ( variableA, "###k" ), variableA >= 1000000, FORMAT ( variableA, "###.0M" ) )Best Regards,
Community Support Team _ Eason