dynamic ranges in columns and rows

[Anonymous]

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

[rafaelmpsantos]

You 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.

[Anonymous]

What is the first column?:

0

1

2

3

...

[rafaelmpsantos]

yeah

Column1
 0 
Column2
0-22

[Anonymous]

@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?

[Anonymous]

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