Forum Discussion
Dynamic selection of Common records between multiple tables
Hello Every one...
I am new to PowerBI and Happy to be part of Power BI Community Family...
I need to Count the Common Records Between the Selected Months and Display them in Visualizations like Barchart...
here are some points as per reqirement:
1.the chart should show the common no'of DC_MATERIAL_NAME count between Seleted months from the filter
2.the month filter should allow only 2 selections at a time.
3.in the above graph the maxmonth refer the maximum month selected from the filter and maxmonth-1 refer the other month selected
4.as and when the bar is clicked it should show the correspondind data records from the table also
5.We need to Pick the latest Status of record when ever it repeates in the month (We can assign the index for each month and can conside the max index)
I have Month Wise latest 4 months data set as below..
Ex :August_2022 to Nov_2022 here is the sampl table
| MARKET | MATERIAL_NAME | PROCESSING_STATUS |
| MME | E-DEG-71E2 | FAILURE |
| MNAO | E-WZG-72A2_XML | SUCCESS |
| MC | E-DEG-72A2 | FAILURE |
| MME | E-WWG-20E1EV_PDF | SUCCESS |
| MME | E-WWG-20E1EV_XML | SUCCESS |
| MNAO | 1A87-1U-17F_MY2016_2018_XML | SUCCESS |
| MME | E-WES-03A1_XML | SUCCESS |
| MC | E-DES-36A1 | FAILURE |
| MME | E-WES-36A2_XML | SUCCESS |
| MNAO | E-WES-74G1_XML | SUCCESS |
| MME | E-WZS-12A2_XML | FAILURE |
| MNAO | E-WEF-72A1_XML | SUCCESS |
| MME | E-WWF-59C1_PDF | SUCCESS |
PaulDBrown @amitchandak @Fowmy @Eyelyn9 @RicoZhou @Vera_33 @Jihwan_Kim @mahoneypat @ImkeF @DenisSlav : Could any of you please help
See attached for a proposal to show bars 1 to 4. I don't understand the logic for bars 5 and 6.
3 Replies
- lbendlin
Super User
You have not provided sufficient sample data. Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Thank you for you response and Help.Please find the below drive link for the excel files.
usp=sharinghttps://drive.google.com/drive/folders/1ZxxDJa8ExfB1yqjSZv-3dZnLgkupwCCN?usp=sharing
My Expected out come is as below:
with a filter like latest 4 months
Those 6 bars shoud show:
Bar1 : Count of total material
Bar2 :Common material folder count between selected 2 months(by default 4months Common material folder count )
Bar3 :Common Success material folder count between selected 2 months(by default 4months Common success material folder count )
Bar4 :Common Failed material folder count between selected 2 months(by default 4months Common failed material folder count )
Bar5:Common material Folder Count Succeeded in Max-1 month( in this case Sep) and Failed in Max month (in this case Oct)(We have data from July to Oct)
Bar6:Common material Folder Count Failed in Max-1 month( in this case Sep) and Success in Max month (in this case Oct)(We have data from July to Oct).
your help would be greatly appreciated thank you in advance.
- lbendlin
See attached for a proposal to show bars 1 to 4. I don't understand the logic for bars 5 and 6.
