Dynamic column Report

[Anonymous]

Hi Team,

Am new to power BI developement. 

How to prepare dynamic column report based on input columns.

Have developed a small report with months as silcer and deafult am taking last 3 months data in report view but my case is when am select Jan to Aug in slicer it suppose to show Jan to Aug data, if i select Jan to Apr to show Jan to Apr data only. Please help on this issue.

[Anonymous]

Hi @Anonymous ,

I'm not sure if i understand you correctly. Are you want show last 3 months data if there's only one date selected in the slicer and show selected months data when there are multipul months selected in slicers?

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[nvprasad · Accepted solution]

Hi

Add date column into the slicer and select "Between" in the top right corner dropdown.

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad

[AllisonKennedy]

I would recommend using a DimDate table and putting a Date slicer and set the properties to Between or Relative Dates.
https://allisonkennedycv.blogspot.com/2020/04/dimdate-what-why-and-how.html

How do you have the default settings at the moment? They need to be configured so that they don't conflict with your DimDate table slicers.