Forum Discussion

ignas's avatar
ignas
Advocate II
8 years ago
Solved

Dynamic column values based on selected date. Need help

Hello   I have this data:     I want to have a date parameter. If I choose 01-04-2018 date then it would mean that all dates before 01-04-2018 are actual and all dates from 01-04-2018 are ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi ignas,

     

    The solution could be as follows.

    1. Create an independent date table. Don't establish relationships with other tables.

    2. Create a slicer.

    3. Create a measure like below.

    Measure 9 =
VAR selectedDate =
    IF ( HASONEVALUE ( 'Table8'[Date] ), MIN ( 'Table8'[Date] ) )
RETURN
    IF ( MAX ( DimDate[Datekey] ) <= selectedDate, "Actual", "Forecast" )

    Dynamic_column_values_based_on_selected_date_Need_help

     


    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Ignas,

 

I'm afraid we can't add a measure in the Legend. Actually, we don't need to do that in your scenario. Because every Axis value only has one Scenario. What't the result you expect?

 

Best Regards,

Dale

ignas's avatar
ignas
Advocate II
8 years ago

Hey v-jiascu-msft

 

Thank you for the response.

Yes of course I need different colors:

We need to know when ACT finished and when BUD/FC starts.

 

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi ignas,

     

    As a workaround, we can change the measure and put it in the field "Color saturation".

    Scenario+ = 
    IF ( MAX ( DimDate[Datekey] ) <= IF ( HASONEVALUE ( 'Table8'[Date] ), MIN ( 'Table8'[Date] ),"Actual"), 1, 0 )

    Dynamic_column_values_based_on_selected_date_Need_help2

     

    Best Regards,

    Dale