Forum Discussion
Dynamic table creation
Hi ww1711,
Please check out the demo in the attachment. Since there are some groups that don't exist in some days, we need to create a [Groups] table first.
1. Create a new table.
Groups = VALUES(Table1[Group])
2. Create a measure.
Rank = VAR ranks = CALCULATE ( RANKX ( ALL ( Groups[Group] ), CALCULATE ( SUM ( Table1[Volume] ) ) ), ALL ( Table1[Month] ) ) RETURN IF ( ranks <= 5, ranks, BLANK () )Best Regards,
Dale
Hi ww1711,
Please check out the demo in the attachment. Since there are some groups that don't exist in some days, we need to create a [Groups] table first.
1. Create a new table.
Groups = VALUES(Table1[Group])
2. Create a measure.
Rank =
VAR ranks =
CALCULATE (
RANKX ( ALL ( Groups[Group] ), CALCULATE ( SUM ( Table1[Volume] ) ) ),
ALL ( Table1[Month] )
)
RETURN
IF ( ranks <= 5, ranks, BLANK () )
Best Regards,
Dale
Really fantastic stuff here, Dale. Thank you for your assistance.
One last ask regarding this... I've rendered what you've got in the table in a stacked column chart and I'm curious as to whether or not I can bypass the automatic coloring of the series. I've got company standard color guidelines that I'd like to apply to each rank at render-time. Is this possible?
Ex: Rank 1 gets #FF0000, 2 gets #FFFF00, etc... It should be mentioned that I'm using PBI Desktop for Report Server (March 2018).
Thanks in advance!
Hi ww1711,
Maybe you can customize the color in the settings. Please refer to the snapshot below. How does the Stacked Column chart look like?
Best Regards,
Dale
