Dashboard Filter by Product and Year

[JonasDedual]

Hi All

I am trying to create a Dashboard. When right clicking on a customer and selecting "Drill Through", it should go to a Dashboard with detailed sales information about this customer. A requirement is that all data for a single customer is shown based on year and product Group. Something like that:

	Current Year	Last Year	2 Years Ago	3 Years Ago
Total
Product A
Product B
Product C
Product D
Product E
Product F

In total I will have 23 Product Groups.

Not sure if that is even possible and where to start. Is there a way to set a filter on Rows and Columns or set a meassure for each individual Field?

Thank you in Advance

[V-lianl-msft]

You could refer to this blog:

https://radacad.com/master-detail-design-with-drillthrough-filter-in-power-bi 

[JonasDedual]

Im sorry when I was not clear.

I have a table with sales data. Eatch Row is representing one customer. When doing a Drrill Through it should open a dashboard with detailed sales information about that customer.

And it should be something like that:

The  above graph should be a tabular or matrix visual.

I dont think that I have to add more filters on the Drill Through pane because it will have an impact on other data that I am showing on the Dashboard:

My current Dashboar is as below:

So I want to add my above requested table visual to the current Dashboard.

[Jihwan_Kim]

Hi, @JonasDedual 

I am not sure how your business or how your case wants to be presented, but please check the below link whether it is what you are looking for.

I roughly created a sample pbix file, and I hope you can have some ideas to start.

All measures are in the sample pbix file.

https://www.dropbox.com/s/mcjda2bt9drmk3x/JonasDedual.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/

[amitchandak]

@JonasDedual , Not very clear to me. In Drill through the report, Disable keep all filter and add other filter you want, I this case you might not want to pass date or something else

for This year, last year and Last to last year you can use with date tbale

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))
Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))

2nd  Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-2,Year),"12/31"))
This year Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR('Date'[Date]),"12/31"))
Last year Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR(dateadd('Date'[Date],-1,Year)),"12/31"))
Last to last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-2,Year),"12/31"))

With date option - Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA

[JonasDedual · Accepted solution]

Hi All

I have found already a solution my self. It was more simple than I have expected 🙂

I had to use a matrix and use the fields as below:

The Result is showing as below: