White Space Anaysis

[FatBlackCat30]

Hello all,

I am wanting to create a chart to do white space analysis but I dont see any examples using Power BI. I am wondering if anyone out there has any examples they have used for white space analysis.

This is purly for fun, not a requirement. 

thanks for the help!

[amitchandak]

Can you explain more on "white space analysis"

[FatBlackCat30]

@amitchandak 

What I want to create is a matrix with companies on the left and our products along the columns. then I want to put a 'x' where each company has our products that way I can see what products I could upsell to our customers  

[amitchandak · Accepted solution]

I tried creating something similar for subcategory sold in cities. Instead of white space " ", I kept Y. Is this what you are looking at

X analysis = if(ISBLANK(CALCULATE(COUNTROWS(Sales))),"Y","X")
// Try
X analysis = if(ISBLANK(CALCULATE(COUNTROWS(Sales)))," ","X")

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

[Manishkm859]

@amitchandak what if I need to create a same view but now I have a slicer with Sub category filter. Now when i filter on Sub Product 1, the table shows all the customers with X on subproduct 1 and other columns also with N

[FatBlackCat30]

@amitchandak  this is perfect. exacly what I am looking for. Thank you very much