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

[matthewiwundu]

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

[v-robertq-msft · Accepted solution]

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.

[matthewiwundu]

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

[Anonymous]

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