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.
v-jianboli-msft
Community Support
Community SupportHi 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.