I have tabular powerBI reports where few columns gets populated dynamically ( Like Year2022 , Year2023 ) within source query.
Rep开发者_高级运维ort looks something like attache image.
Now Business Require slicer/Filter in such a way that He can filter those dynamic columns and he gets control to show and hide columns based on slicer selection with report.
I have find the solution but that is more suitable for filtering Static Columns , Is there any way we can filters Dynamic Columns through slicers .
Since Dynamic Columns numbers not fixed sometime ,
For one data refresh i can see Year2022, Year2023 and for other Year2025 ,Year2026.
Any solutions, direction will be appreciated
enter image description here
精彩评论