topic Re: How to Display month Value in Card visual instead of Total value in DAX Commands and Tips

How to Display month Value in Card visual instead of Total value

matthewiwundu — Tue, 26 Oct 2021 20:39:49 GMT

I am new to power BI. I want to display my month Values using card visuals but I want it to default to Months and not Total value.

I have a table that says. How can I write the DAX formula to achieve this?

Date Monthly Violation Total Violation

Re: How to Display month Value in Card visual instead of Total value

Anonymous — Tue, 26 Oct 2021 20:46:17 GMT

Have you tried the Time Intelligence > Month-to-Date Total under the Quick measure?

Re: How to Display month Value in Card visual instead of Total value

v-robertq-msft — Mon, 01 Nov 2021 09:28:03 GMT

Hi, matthewiwundu

According to your description, you want to make the card chart you created displays default to Months and not Total value, right? I think you can create a calculated column and a slicer to filter your card chart to achieve your requirement, you can follow my steps:

Create a calculated column:

Month = FORMAT([Date],"mmmm")

Then you can create a month slicer and a card chart place the measure like this:

You can download my test pbix file below

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

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

Re: How to Display month Value in Card visual instead of Total value

matthewiwundu — Wed, 10 Nov 2021 04:20:32 GMT

Yes but i want to see when you open the report it defaults to a month total value without slicer. Then you can slice to view the various month. Eg . Total sales for jan 15units, or feb 13units