Forum Discussion

Sanket570's avatar
Sanket570
Frequent Visitor
6 years ago

Dynamically show latest month from date column if nothing selected or no any slicer is selected

hello folks,   I want to show latest or max month on the column chart visual on the basis on my date column dynamically if nothing is selected from any visual and if any visual or silcer is selecte...
Need Help
v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Sanket570 ,

 

You need a measure as below:

Measure = IF(SELECTEDVALUE('Table'[Date]) in FILTERS('Table'[Date]),SELECTEDVALUE('Table'[Date]),MAX('Table'[Date]))

Finally ,you will see :

For the related .pbix file,pls click here.

 

Best Regards,

Kelly

Sanket570's avatar
Sanket570
Frequent Visitor
6 years ago

i want to use that measure for the column chart visual.if i going to put this measure into the value field then its not working

 

please provide the needed

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Sanket570 ,

     

    Based on my test, column chart visual only support the value of the whole number,you cant put other type of data in the field of value, here, in your requirement ,you hope to put a date type value in a column as its value, and it's not supported, all you can do is to change the date type to the whole number,and you will see as below:

     

    Is it what you need ? If not,my suggestion for you is to change for another visual,such as card,etc.

     

    Best Regards,
    Kelly

    • Sanket570's avatar
      Sanket570
      Frequent Visitor
      6 years ago

      hello sir i got the same output as you are showing but this moth is also categorized into the date of the month at axis 

      • Sanket570's avatar
        Sanket570
        Frequent Visitor
        6 years ago

        means suppose the month is november then iit will scattered into november date also