Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
What is the first column?:
0
1
2
3
...
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:
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 |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |