Forum Discussion
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 pull a card and get that field into it, it is giving me an average of all the values but I want to show only 55 in the card visualizations. Can you guys help me ingetting the current months value in a title instead of average of complete field?
Thanks,
Keerthi
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
4 Replies
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 ZhangThank you for a quick response and it helped me a lot.
Thank you for a quick response and it helped me a lot.
One Quick Question: I was given a Dax Function to calculate Current month
here we go :
CheckCurrentMonth = if(MONTH('Query1'[Date])=MONTH(NOW()),"Current Month",Format('Query1'[$CreatedTime], "YYYY mmmm"))
this function gives me the current days number. In the snapshot, for February the FDR% is 48%. (02/01/2017 is 50% and 02/02/2017 is 36%) so I need a ovverall February % which is 48%. But I get only 36 (Todays count). Not sure how to get the total months Percentage. Is this possible? If so, can you help me getting it
-Keerthi
Thank you for a quick response and it helped me a lot.
One Quick Question: I was given a Dax Function to calculate Current month
here we go :
CheckCurrentMonth = if(MONTH('Query1'[Date])=MONTH(NOW()),"Current Month",Format('Query1'[$CreatedTime], "YYYY mmmm"))
this function gives me the current days number. In the snapshot, for February the FDR% is 48%. (02/01/2017 is 50% and 02/02/2017 is 36%) so I need a overall February % which is 48%. But I get only 36 (Todays count). Not sure how to get the total months Percentage. Is this possible? If so, can you help me getting it
-Keerthi
