Forum Discussion
3 dimensions chart (not 3d)
Hello Community,
I need to create a 3 dimensions chart, my 3 dimensions are :
- origin (old, new)
- location (country for example)
- time
target is to see by location usage of "old" and "new" and see when line cross together...
Here is an example found on internet related to series (just to help to understand my need):
thanks,
Hi nicolasd1 ,
If the information is has you have it you need to unpivot the information and add split the values in attribute (New, Old), Company, values
Then create measures with the following syntax:
New A = CALCULATE(SUM('Table'[Value]);'Table'[Country] ="A" ;'Table'[Attribute] = "New")Then replace the attribute and country for each one and then use the 4 measures on your chart.
Check PBIX file attach.
Yhis response is given with the information you reported if you need something more dinamic I need more information.
1 Reply
Hi nicolasd1 ,
If the information is has you have it you need to unpivot the information and add split the values in attribute (New, Old), Company, values
Then create measures with the following syntax:
New A = CALCULATE(SUM('Table'[Value]);'Table'[Country] ="A" ;'Table'[Attribute] = "New")Then replace the attribute and country for each one and then use the 4 measures on your chart.
Check PBIX file attach.
Yhis response is given with the information you reported if you need something more dinamic I need more information.