Forum Discussion
Dynamic column Report
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.
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
3 Replies
- 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. 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 PrasadHi 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.
