Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Update Visualization Base on Current Month

Hi All, I recieve an excel report with various KPIs are rows and the months as columns (see below for illustration) . I currently have a gauge dial to report on the current month vs goal but this req...
Need Help
v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, Anonymous 

 

Based on your description, I created data to reproduce your scenario.

Table:

 

You may create two calculated columns as below.

Month-Year = VALUE(FORMAT('Table'[Date],"yyyymm"))
Flag = 
var _currentmonthyear =  
IF(
    MONTH(TODAY())<10,
    VALUE(YEAR(TODAY())&"0"&MONTH(TODAY())),
    VALUE(YEAR(TODAY())&MONTH(TODAY()))
)
return
IF(
    'Table'[Month-Year]=_currentmonthyear,
    1,
    0
)

 

Then you need to set visual level filter as 'Flag' = 1 to display the result.

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.