Skip to main content

Power BI

New

Small Multiples + Calculation group - Allow multiple numeric formating ($, %, Whole Number,, Decimals in single Chart)

Vote (6) Share
Sam Rock's profile image

Sam Rock on 16 Aug 2021 02:37:35

Small Multiples is already a very popular and powerful feature. But when combined with Calculation group , it takes the feature to another level!



I have a scenario  where my calculation group returns values with variety of numeric values with different formatting like , currency, percentage, whole number [eg: Revenue ($), Revenue growth percentage (%), Order count (whole number)]. I create a daily trend chart using the Calculation group as small multiple column. This gives me single chart with breakdown of all the above calculations with added advantage of single scroll bar (otherwise I need three charts with three horizontal scroll bar on X Axis)!



Only problem is that now the chart doesn't properly respect Formatting option set in the calculation group. Y Axis usually scales by the highest value returned by the measure.



Please add option to allow variety of numeric formatting option within a single small multiple Chart.