How to achieve Dynamic date attribute selection for Matrix columns

[Surendra_thota]

Hi All

currently in Matrix we are using date hierrchy , instead of that we have to select day/week/month based on the selection any of these values used in columns of matrix

I have tried to create a table  with values  Day , week , Month

tried to create measure like this but columns are not coming only measure are coming

Selected Value =
IF(HASONEVALUE( SelectedValue[column]),
SWITCH(VALUES( SelectedValue[column]),
"Day", Date[Day],
"Week", Date[Week Ending],
"Month", Date[Month] )
), "Please select only one value to display")

Please let me know is there any way to select  Date[Day] , Date[Week Ending] ,Date[Month] dynamiclly in matrix 

[Dgarach]

Hi,

I am trying to the same thing but with charts to be able to have, for example, 2016 selected, then able to switch between "Monthly", "Weekly" and "Daily" so that the axis scales based on the selection.

No luck as yet but I hope someone else can assist or MS updates PBI so that it can.

Darshik

[v-yuezhe-msft]

@Surendra_thota,

I am not very clear about your requirement, please help to share sample data of your  table and post expected result with screenshot.

If you want to dynamically hide column in Matrix based on selection, it is not possible. One option is to hide or show the values in the column by creating measures, but column headers are still appeared even there is no data.

Regards,
Lydia