Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Use one date table

Hi everyone,   I`ve using power bi since one year, and i cant solved this. I need to have one table of dates in order tu use that table to filter many other tables. The thing is that i cant make ...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI jthomson 

 

I show u an example. As i say i have a page with multiple cards and i want all to be filter by one slicer, so that the client can select the year and see the changes:

As you can see, i want that de slicer of Year (2020, 2019,2018) filter in the same time: Headcounts, Trainings, Hirings, Terminations, etc

I show you an example of a Power BI report:

https://powerbi.microsoft.com/es-es/partner-showcase/agile-analytics-hr-analytics/

 

See page "Employee Overview" for example.


Let me know if you understand


Thanks

jthomson's avatar
jthomson
Solution Sage
6 years ago

Well getting rid of the relationship between employees and training should do it, but without knowing everything else that's going on in your report and with your calculations it's impossible to say if that'd break anything or if that's a good idea