How to give Year, Quarter, Month and Week filters to Power BI Embedded report using JavaScript?

[Pitchaimuthu]

I have embedded the Power BI reports using javascript. But in our requirement, user wants to see the ProductSalesCategory in Year, Quarter, Month and Week. In our report table having the Product Sales Date field it is there. So that I have created the custom filters in ASP.Net using javascript. But I could not able to apply the Year, Quarter, Month and week filters to the Embedded Report. Please give me how to do this?

[Eric_Zhang]

---

@Pitchaimuthu wrote:

I have embedded the Power BI reports using javascript. But in our requirement, user wants to see the ProductSalesCategory in Year, Quarter, Month and Week. In our report table having the Product Sales Date field it is there. So that I have created the custom filters in ASP.Net using javascript. But I could not able to apply the Year, Quarter, Month and week filters to the Embedded Report. Please give me how to do this?

---

Have you got a calendar table as in this link and link it to your table?  And then you can try to apply filters to  Year, Quarter, Month and week columns in that calendar table.

You can also leverage the drill down feature as well, I think.