Forum Discussion
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...
v-kelly-msft
Community Support
Community SupportHi 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
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
means suppose the month is november then iit will scattered into november date also
- v-kelly-msft