Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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
Can you explain more on "white space analysis"
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
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
@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
@amitchandak this is perfect. exacly what I am looking for. Thank you very much