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, ...
rafaelmpsantos
Responsive Resident
Responsive ResidentYou need to create a RANGE Table, something like this
0 0-22
1 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.
What is the first column?:
0
1
2
3
...
- rafaelmpsantos
yeah
Column1
0
Column2
0-22@rafaelmpsantos But I do not understand what is a purpose of this and what it is exactly.
I thinking of doing a crossjoin SIZE with SIZE
but it is not fully working:
here is the data model:
- rafaelmpsantos
Can you send me this pbi file?