Forum Discussion
Last 4 years on table
Not sure that I can make it clearer than SQLBI, but I'll try to explain the general principles.
You need a second copy of the date table, because you want to be able to select a single year and yet display multiple years in the visual. So you select a single year from the main date table, and you can then use dates from the copy inside the visual to show the values that you want to.
The main concept is that you take the value selected from the main date table and use that to generate the list of dates that you want to show in the copy table. The rest is about making sure that the list of dates in the copy table correctly filter the main fact table.
I'd suggest that you watch the video, then read the article and let it sink in a bit. Watch the video again, and then try and copy the steps that Alberto details in the article and put them into your model. Also, download the sample file from the article and have a look at how it works in there.
Thanks johnt75 but I'm slightly dumb, is there an easier guide or some more complete example?
I've heard about calculation groups but I'm not really familiar with the concept.
Sorry for that and really appreciated the help!
- FBergamaschi
Super User
Hi ricardo_martins the example is not complex but I undersstand your reply
If you can share your pbix via a could service, I can implement that and send it back
If this helped, please consider giving kudos and mark as a solution
@me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
hi FBergamaschi, thanks for your response and availability to help, I went with johnt75 solution as I felt it would be very lazy for me to just ignore the solution where I needed to to some work instead of having someone do it for me. Thanks again anyway!
