Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone.
How would I ensure the maximum value (in this case March) be coloured differently to the rest of the values? Thanks
Solved! Go to Solution.
Hello @Anonymous
you need to create two measures:
MaxValue = VAR _MAXValue = MAXX( ALL( 'Date'[Month], 'Date'[Month Number] ), [Total Sales] ) RETURN IF( [Total Sales] = _MAXValue, _MAXValue, BLANK() )
and
SalesTotal = VAR _MAXValue = MAXX( ALL( 'Date'[Month], 'Date'[Month Number] ), [Total Sales] ) VAR _TotSales = [Total Sales] RETURN IF( _TotSales = _MAXValue, BLANK(), _TotSales )
where [Total Sales] is this measure (this depends on your model and is the 1 your currently using in your chart above):
Total Sales = SUMX( Sales, Sales[Net Price] * Sales[Quantity] )
then add STACKED bar chart with months on the X axis and the two measures. Also for temporal data, i advise you to place it horizontally and not vertically
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Hello @Anonymous
you need to create two measures:
MaxValue = VAR _MAXValue = MAXX( ALL( 'Date'[Month], 'Date'[Month Number] ), [Total Sales] ) RETURN IF( [Total Sales] = _MAXValue, _MAXValue, BLANK() )
and
SalesTotal = VAR _MAXValue = MAXX( ALL( 'Date'[Month], 'Date'[Month Number] ), [Total Sales] ) VAR _TotSales = [Total Sales] RETURN IF( _TotSales = _MAXValue, BLANK(), _TotSales )
where [Total Sales] is this measure (this depends on your model and is the 1 your currently using in your chart above):
Total Sales = SUMX( Sales, Sales[Net Price] * Sales[Quantity] )
then add STACKED bar chart with months on the X axis and the two measures. Also for temporal data, i advise you to place it horizontally and not vertically
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Worked great thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |