Forum Discussion

v-kered's avatar
v-kered
Regular Visitor
9 years ago
Solved

Getting Current monht or week value by using any visualizations

Hi,   I have a graph which gives me the monthly trend. Below is a snapshot of it. In the above image you can find the monthly view. So for the current month "January" the value is 55. when I p...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi v-kered,

    You forgot to add the snapshot of your graph. Please help to post sample data of your tables if the following methods don't solve your issue.

    I am not sure what fields you use to create the graph and the card. But if you want to display value of specific month in the Card visual, you can create a slicer using monthname field, and use the slicer to filter the card to show value for "January", there is an example for your reference.


    Or you can drag monthname field to visual level filters, then select "January" in the filter to show value for "January".




    However, if you want to dynamically show value for current month in card visual, you would need to create calculated column using the following formula, then create slicer using this calculated column  and use it to filter your card visual.

    CheckCurrentMonth= if(MONTH('Date'[Date])=MONTH(NOW()),"Current Month",Format('Date'[Date], "YYYY mmmm"))

     

    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi v-kered,

You forgot to add the snapshot of your graph. Please help to post sample data of your tables if the following methods don't solve your issue.

I am not sure what fields you use to create the graph and the card. But if you want to display value of specific month in the Card visual, you can create a slicer using monthname field, and use the slicer to filter the card to show value for "January", there is an example for your reference.


Or you can drag monthname field to visual level filters, then select "January" in the filter to show value for "January".




However, if you want to dynamically show value for current month in card visual, you would need to create calculated column using the following formula, then create slicer using this calculated column  and use it to filter your card visual.

CheckCurrentMonth= if(MONTH('Date'[Date])=MONTH(NOW()),"Current Month",Format('Date'[Date], "YYYY mmmm"))

 

Thanks,
Lydia Zhang