How to Select Column dynamically in Table graphics according to Date

[Chandra_maha]

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. 

[v-jianboli-msft · Accepted solution]

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.

[Anonymous]

Hi,

I think this will help,

https://p3adaptive.com/2018/01/dynamic-attributes-power-bi-report/

[Chandra_maha]

This will work if I opt for the slicer. However, I need to reflect the column with respect to current month dynamically. 

[Thennarasu_R]

Hi !
@Chandra_maha 
You Can use Field Parmeters .
Thanks ,
Thennarasu 

[Chandra_maha]

Thank 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?