Forum Discussion
Chandra_maha
Helper I
Helper IHow to Select Column dynamically in Table graphics according to Date
Hi Everyone, I am trying to select the Column Dynamically in Table graphics according to Date. Ex - I have data for various countries with respect to Month. However, Month data is entered as...
Hi Chandra_maha ,
Based on your description, I have created a simple sample:
Please try:
Unpivot the Date columns:
Then create a measure:
Measure = IF(LEFT(MAX('Table'[Attribute]),3)=FORMAT(TODAY(),"MMM"),1,0)Apply it to the visual:
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thennarasu_R
Responsive Resident
Responsive ResidentHi !
Chandra_maha
You Can use Field Parmeters .
Thanks ,
Thennarasu
Chandra_mahaThank you Thennarasu_R for suggesting the "Filed Parameter". If I use that, then I have manually selected the Column of various months every time where there is a change in Month.
Is there a way, the month gets selected or changes dynamically with a date?