Forum Discussion
How 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 shown below.
I am creating a table visual, where I want to see the data for the current month only. Following should be the output
For January, I should get the data for Jan 23, and for February, I should get the data of Feb 23. This process should happen dynamically.
I tried a few ways but could not get it.
Thank you.
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.
5 Replies
Hi !
Chandra_maha
You Can use Field Parmeters .
Thanks ,
ThennarasuThank 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?
This will work if I opt for the slicer. However, I need to reflect the column with respect to current month dynamically.
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.
