Solved: Re: Matrix Visual not populating correctly

HemanthV · ‎05-24-2021

Hi Guys,

I am facing the below issue, Please help me.

expected output:

The first visual is a table visual here i am getting data for highest batch number for each_time frame. I have achieved this by using following measure:

Max in group = IF(CALCULATE(MAX(emcodatas[batch]),ALLEXCEPT(emcodatas,emcodatas[time_frame]))=MAX(emcodatas[batch])

,1,0)

Applied this measure in visual level filter and set it to 1. But when i change the visual from table to matrix and set the time_frame in columns field. i am getting only one symbol instead of 7 symbols. When i export the data from matrix visual i am getting 7 symbols in excel, but it is not showing here.

I don't know what's the issue here. I have tried a custom matrix visual, It is working fine. But i wan't the default matrix visual. Please help me!

Thanks in advance.....!!!!

@Greg_Deckler , @Pragati11 , @amitchandak, @DataInsights, @Fowmy

parry2k · ‎05-24-2021

@HemanthV solution attached. I hope it helps. When you use measure in the visual level filter, it doesn't have the context of the batch and that's why it was not working for you. Anyhow, I have made the measure that contains the logic to include only the latest batch and you don't need to do a visual level filter.

Tweak it as per your need.

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

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

parry2k · ‎05-24-2021

@HemanthV use Calculation groups to switch between the latest batches or all the batches.

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 · ‎05-24-2021

@HemanthV solution attached. I hope it helps. When you use measure in the visual level filter, it doesn't have the context of the batch and that's why it was not working for you. Anyhow, I have made the measure that contains the logic to include only the latest batch and you don't need to do a visual level filter.

Tweak it as per your need.

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

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.

HemanthV · ‎05-24-2021

Hi @parry2k ,

Thank you for the solution. My requirement is that by default, all visuals in the page should show latest batch information, The user can reset this and see previous batch data too. How to implement this?

parry2k · ‎05-24-2021

@HemanthV it will be easier to figure out if you share pbix file with sample data.

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

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.