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
prashantg364
Helper II
Helper II

How to create the visual

Hi,

I have 2 tables in my data set.
Table 1 has 2 columns, Product ID & Category against each Product ID

Table 2 has multiple columns, showing service count of Category on a given date.

 

Ex 1: Product ID 123 has 3 Category - 1000,1001,1002 as shown in table 1

on 1 Jan, out of 3 only 2 category has service count i.e 1000 & 1001

 

Ex2: 

Product ID 126 has 5 Category - 2001, 2002, 2003, 2004, 2005 as shown in table 1

on 1 Jan, out of 5 only 3 category has service count i.e 2001, 2002, & 2005

 

 

Output i am looking for to check on a given date which category has how many service count and which category has 0 count -  as shown in Output table

 

Pls suggest



Table 1: Product ID-Category

Product IDCategory
1231000
1231001
1231002
1241551
1251665
1251666
1262001
1262002
1262003
1262004
1262005
127950
127951

 

Table2: Product ID-Category-Service

Product IDCategoryDateService Count
123100001-Jan1
123100101-Jan1
124155101-Jan2
125166501-Jan3
125166601-Jan3
126200101-Jan1
126200201-Jan1
126200501-Jan1
12795001-Jan4
12795101-Jan2

 

Output Table

Product IDCategoryDate10001001100215511665166620012002200320042005950951
123100001-Jan1            
123100101-Jan 1           
123100201-Jan  0          
124155101-Jan   2         
125166501-Jan    3        
125166601-Jan     3       
126200101-Jan      1      
126200201-Jan       1     
126200301-Jan        0    
126200401-Jan         0   
126200501-Jan          1  
12795001-Jan           4 
12795101-Jan            2
1 ACCEPTED SOLUTION
xifeng_L
Solution Sage
Solution Sage

Hi @prashantg364 ,

 

You can refer to below demo.

 

xifeng_L_0-1715787898613.png

 

Demo - How to create the visual.pbix

 

 

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

 

Thank you~

 

View solution in original post

1 REPLY 1
xifeng_L
Solution Sage
Solution Sage

Hi @prashantg364 ,

 

You can refer to below demo.

 

xifeng_L_0-1715787898613.png

 

Demo - How to create the visual.pbix

 

 

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

 

Thank you~

 

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.