Forum Discussion
dynamic ranges in columns and rows
I got the dynamic table with sales by price and by size.
Sales is calculated between the points selected on slicers.
This works fine but doesnt not look good. Instead of values in rows and column, I would like to have ranges.
For instance:
Instead of size =111, I would like to have 0-111 in column
Instead of price = 33, I would like to have 22-33 in rows
Column and rows values are dynamic based on slicer's selection
As I know dynamic columns are not supported but maybe is a workaround?
Any unconventional ideas very appreciated
6 Replies
- rafaelmpsantos
Responsive Resident
You need to create a RANGE Table, something like this
0 0-221 0-22
2 0-22
3 0-22
4 0-22
5 0-22
6 0-22
...
and then create a relationship in both ways, between Table[PRICE} and NewTable[column1]
and then do the same with the SIZE column creating another table.- rafaelmpsantos
yeah
Column1
0
Column2
0-22
