Forum Discussion
How to link between two charts?
It was fixed by adding a relationship between the tables with the MES column.
Thank you!
Best regards.
Nice day. The file is in Spanish. What language do you want to translate it into?
There I separated the four graphics more clearly on a single screen:
1) Total billing graph (correct values: the sum of all the months gives $486,250,492)
2) Percentage of training that gives error.
3) Training Chart
4) Total billing per month (there you can see the error that the total shown is 323,081,275, that's why you miscalculate the percentage).
How could I correct it?
I attach the link to the file
https://drive.google.com/file/d/1VL8NpMeIeB-fx2JTxaUATOlyriNFroZE/view?usp=sharing
Hi,
There must be a date column in the Calendar table and a relationship from the Date column of your various Fact tables to the Date column of the Calendar table. Do that and share the download link of the PBI file.
Hello! How is it going?.
There I made two relationships between the MES calendar table and the MES column of each table, and the problem remains the same.
It seems to me that it is as you say, the MES column of each table is not unified. How is it done?
https://drive.google.com/file/d/1G4XHm66yQHUyuM_JNsaPzNnGtFGqu-D6/view?usp=sharing
Thank you
Hello! It's as you say. There I was able to generate a relationship in the following way and it was good for me !.
Thanks a lot!!!.
Best regards.