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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

Top Solution Authors