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, ...
What is the first column?:
0
1
2
3
...
rafaelmpsantos
Responsive Resident
Responsive Residentyeah
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?
At this moment I can place data here:
fact table
year product color size sales value volume 2017 chair black 120 700 2 2017 chair white 120 701 3 2017 chair yellow 130 702 4 2017 chair green 140 703 5 2017 chair brown 150 704 6 2017 chair fiolet 160 705 7 2017 table black 120 706 8 2017 table white 120 707 9 2017 table yellow 130 708 10 2017 table green 140 709 11 2017 table brown 150 710 12 2017 table fiolet 160 711 13 2018 chair black 120 300 14 2018 chair white 120 301 15 2018 chair yellow 130 302 16 2018 chair green 140 303 17 2018 chair brown 150 304 18 2018 chair fiolet 160 305 19 2018 table black 120 306 20 2018 table white 120 307 21 2018 table yellow 130 308 22 2018 table green 140 309 23 2018 table brown 150 310 24 2018 table fiolet 160 311 25 2018 table red 170 312 26 price table (from 1 to 9999)
PRICE 1 2 3 4 5 6 7 8 9 10 11 12 size table (from 1 to 9999)
SIZE 1 2 3 4 5 6 7 8 9 10 11 12