dynamic column based on slicer

[avin_leo]

Hi All,

anyone have solution to create dynamic column (Table view) based on slicer last date (Report view).

[avin_leo]

in short whenever a as of date selected in slicer, will get month number for that quarter

[avin_leo]

so column number are based on selected date lets say if i select April month column number needs to start from 1 if selected May then starts from 2 if selected Jun then 3 if selected july then 1 ... 

[avin_leo]

[Ritaf1983 · Accepted solution]

Hi @avin_leo 
There is no such option because table columns are "static",
Slicer is something that happens on the flight.
There are many options to solve this issue with measures.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523