Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
AndradeRobson
Helper II
Helper II

DAX function

Dear all, good afternoon!

Sorry, rectifying.

Can you help me.

I have a table with the column date, account, history and value. I have a DAX SUM('2000_Razao_Centro_Custo_Insight_Ind'[Movimento]) function where the system calculates from January to December 2022 on a monthly basis, but I need to maintain the previous function and now a new measure to calculate another % column in the same "Matrix", but the % cannot appear month by month, only the annual % of this new measure.

Can someone help me.

Robson

Tela_2.jpg

1 ACCEPTED SOLUTION
parry2k
Super User
Super User

@AndradeRobson I have done series of videos on how you can show multiple totals in Matrix visual, check these here and hope it will help you what you are looking for:

 

Maximizing Power BI Matrix Visual: Displaying Multiple Totals for Better Insights - Part 1 - YouTube

Maximizing Power BI Matrix Visual: Displaying Multiple Totals for Better Insights - Part 2 - YouTube

Maximizing Power BI Matrix Visual: Displaying Multiple Totals for Better Insights - Part 3 - YouTube



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

4 REPLIES 4
parry2k
Super User
Super User

@AndradeRobson On another note, yes I'm working on starting a course in a few months, and one important, I'm not going to record my courses like others available in the market but it will be live (remotely) so that we all can interact with each other. Will announce it on my YT channel when it is ready. Thanks for your interest.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

parry2k
Super User
Super User

@AndradeRobson Glad to hear that these videos were helpful. To show %, you can change the format string in the calculation item.

 

In TE2 (screenshot below), chose Format String Expression for that calculation item and give it the string for %

 

"#,0.00%"

 

Well, you can subscribe to my channel youtube.com/@PowerBIHowTo - that's where I put all my crazy videos 🙂



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

AndradeRobson
Helper II
Helper II

Good afternoon!

Thank you very much, the application helped me a lot, as I have been looking for this solution for a long time.

The result was as expected. Of course, as we progress, new ideas emerge.

The result of the explanation follows:

 

Captura de tela 2023-09-27 170551.jpg


A question:
In this image sent, is it possible to change the numbers to, for example, 48.17%? Decrease decimal places?

Do you have courses or other channels so I can follow you?

Att.

Robson

parry2k
Super User
Super User

@AndradeRobson I have done series of videos on how you can show multiple totals in Matrix visual, check these here and hope it will help you what you are looking for:

 

Maximizing Power BI Matrix Visual: Displaying Multiple Totals for Better Insights - Part 1 - YouTube

Maximizing Power BI Matrix Visual: Displaying Multiple Totals for Better Insights - Part 2 - YouTube

Maximizing Power BI Matrix Visual: Displaying Multiple Totals for Better Insights - Part 3 - YouTube



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.