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
@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.
@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.
@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.
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:
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
@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
Power BI Monthly Update - September 2024
Check out the September 2024 Power BI update to learn about new features.
Microsoft Fabric & AI Learning Hackathon
Learn from experts, get hands-on experience, and win awesome prizes.
Fabric Community Update - September 2024
Find out what's new and trending in the Fabric Community.
