Forum Discussion

Surendra_thota's avatar
Surendra_thota
Helper II
9 years ago

How to achieve Dynamic date attribute selection for Matrix columns

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 

General Comment
Need Help
Tips and Tricks
Tutorial Requests

2 Replies

  • Dgarach's avatar
    Dgarach
    Regular Visitor
    9 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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