Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Veera Halikal

Hi, I am Veera from India, working as data analyst in startup. Need a help to Build Power BI reports for new project. At present I have scenario where User is expecting Bubble plot graph in finance ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Final customer expectation from this Bubble graphSure I will share you sample data to create the graph. 

 

Main Table Csv file has:

  Y-AxisLegendX - AxisX-AxisSize
FactIdDoc IdSpreadBpsBpsNameLoan Start DateQuarterYearLoanStartDate Loan Amount 
12993225p12/9/2012Q1 2012325000
22993275p32/9/2012Q1 201225000
32992350p62/1/2013Q1 201323000
42992400p82/1/2013Q1 201343072
53050325p52/1/2013Q1 201383500
63081250p21/16/2014Q1 20148000
73176275p33/6/2014Q1 201415000
82898562p101/29/2016Q1 2016210900
92898562p101/29/2016Q1 201653553
103089525p92/11/2016Q1 20161275000

 

For this I joined Date Dimension table to get Date Hierarchies as Year, Quarter and Month also Quarter_Year as extra Field as above mentioned along with date field Q1 2001 like data.

 

Please use this above sample data for creating Bubble plot graph and verify

and confirm me about the Power BI limitation to use in Bubble chart as date fields in X axis.

 

Snap shot of Graph sample:

 

 This is how customer expecting final graph when I drill down to Quarter year Level, my graph is working fine for Year and Days...but not for Monht, Quarter and Quarter-Year combinations.

Please suggest solution to build tis graph and would great help to convince customer to use PBI tool instead of other reporting tool.