Need help displaying months with unavailable material codes in Power BI

Anonymous — Sun, 09 Jul 2023 16:08:52 GMT

Hello Power BI Community,

I'm facing a challenge in Power BI and would appreciate your expertise and guidance to find a solution. In my dataset, I have two columns: "Material Code" and "Month." Some material codes are not available for certain months, while they may be available for other months.

My goal is to create a visualization that displays the months for which material codes are not available. In other words, I want to identify the months where there is no record of a specific material code in the dataset.

Could you please suggest the best approach or provide guidance on how to achieve this in Power BI? Any recommended data modeling techniques, measures, or visualizations would be greatly appreciated.

I am giving the below Image of my Data which I tried in Matrix Visual but it is showing all the Unvailable & available Rawmaterial codes.

If I Make requirement in simple line :- I need to show the Rawmaterial code 1000101000 only for Jan, Feb & March Month

I need to show the Rawmaterial code 1005501000 only for Jan, Feb, March, April & May .

Like wise for all Rawmaterial code.

Note :- Somehow I need to know Any particular Rawmaterial code in which and all months its not available.

Thank you in advance for your assistance!

Re: Need help displaying months with unavailable material codes in Power BI

lbendlin — Wed, 12 Jul 2023 00:54:36 GMT

To report on things that are not there you need to use disconnected tables and/or crossjoins

topic Re: Need help displaying months with unavailable material codes in Power BI in DAX Commands and Tips

Need help displaying months with unavailable material codes in Power BI

Re: Need help displaying months with unavailable material codes in Power BI