Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Lucy64
Helper III
Helper III

Line and clustered column chart error

I created a dashboard using the Line and Clustered Column Chart, however when pass this to another user there is an error and does not display this particular graph.  All other visuals work.  I changed the visual to a Clustered Column Chart and the data is displayed.  Any ideas what is happing? the source data is linked correctly and we are both using the latest version of Power BI.

6 REPLIES 6
Eric_Zhang
Employee
Employee


@Lucy64 wrote:

I created a dashboard using the Line and Clustered Column Chart, however when pass this to another user there is an error and does not display this particular graph.  All other visuals work.  I changed the visual to a Clustered Column Chart and the data is displayed.  Any ideas what is happing? the source data is linked correctly and we are both using the latest version of Power BI.


@Lucy64

What does the error say? Can you ensure that the data in your PC are the same(in metadata) with the one who receive and edit the source file in PBIX?

Here is a screenshot and details of the error:LineBarChart Error.PNG  

 

 

 

 

 

 

 

 

 

 

Cannot read property 'window' of undefined

Recent Actions
RemoveProjection, VisualConversion, VisualConversion, VisualConversion, AddFieldInRole, RemoveProjection, AddFieldInRole, VisualConversion

Active Section Contract
{"id":0,"name":"ReportSection","displayName":"Page 1","ordinal":0,"visualContainers":[{"x":10,"y":0,"z":1,"width":750,"height":330,"config":"{\"layouts\":[{\"id\":0,\"position\":{\"x\":10,\"y\":0,\"z\":1,\"width\":750,\"height\":330,\"angle\":0}}],\"singleVisual\":{\"title\":{\"text\":\"WC Pounds Poured vs Pounds Baled per Week 2016\",\"show\":true,\"fontSize\":\"16\",\"alignment\":\"center\",\"fontColor\":\"#303637\"},\"border\":{\"show\":true},\"visualType\":\"lineChart\",\"projections\":{\"Y\":[{\"queryRef\":\"Sum(vwScalesDataFabricationNetValue.Pound Bailed)\"},{\"queryRef\":\"Sum(Pounds Poured.Pound Poured)1\"}],\"Category\":[{\"queryRef\":\"vwScalesDataFabricationNetValue.ActualWeek\"}]},\"prototypeQuery\":{\"Version\":2,\"From\":[{\"Name\":\"v\",\"Entity\":\"vwScalesDataFabricationNetValue\"},{\"Name\":\"p2\",\"Entity\":\"Pounds Poured\"}],\"Select\":[{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"v\"}},\"Property\":\"Pound Bailed\"}},\"Function\":0},\"Name\":\"Sum(vwScalesDataFabricationNetValue.Pound Bailed)\"},{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"p2\"}},\"Property\":\"Pound Poured\"}},\"Function\":0},\"Name\":\"Sum(Pounds Poured.Pound Poured)1\"},{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"v\"}},\"Property\":\"ActualWeek\"},\"Name\":\"vwScalesDataFabricationNetValue.ActualWeek\"}]},\"objects\":{\"dataPoint\":[{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#0088ff'\"}}}}}},\"selector\":{\"metadata\":\"Sum(Pounds Poured.Pound Poured)\"}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#ff0a22'\"}}}}}},\"selector\":{\"metadata\":\"Sum(vwScalesDataFabricationNetValue.FabricationNetValue)\"}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#ff2824'\"}}}}}},\"selector\":{\"metadata\":\"Sum(vwScalesDataFabricationNetValue.Pound Bailed)\"}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#437eff'\"}}}}}},\"selector\":{\"metadata\":\"Sum(Pounds Poured.Pound Poured)1\"}}],\"trend\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}}}}],\"categoryAxis\":[{\"properties\":{\"axisType\":{\"expr\":{\"Literal\":{\"Value\":\"'Categorical'\"}}},\"showAxisTitle\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}}}}],\"valueAxis\":[{\"properties\":{\"showAxisTitle\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}},\"labelDisplayUnits\":{\"expr\":{\"Literal\":{\"Value\":\"1D\"}}},\"axisScale\":{\"expr\":{\"Literal\":{\"Value\":\"'log'\"}}}}}],\"y1AxisReferenceLine\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}}},\"selector\":{\"id\":\"0\"}}],\"labels\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}}}}]}},\"name\":\"VisualContainer\"}"},{"x":10.15572105619499,"y":360.5280974949221,"z":1,"width":750,"height":330.0609343263372,"config":"{\"layouts\":[{\"id\":0,\"position\":{\"x\":10.15572105619499,\"y\":360.5280974949221,\"z\":1,\"width\":750,\"height\":330.0609343263372,\"angle\":0}}],\"singleVisual\":{\"title\":{\"text\":\"WC Pounds Baled per Period Including Prediction 2016\",\"show\":true,\"fontSize\":\"16\",\"alignment\":\"center\",\"fontColor\":\"#303637\"},\"border\":{\"show\":true},\"visualType\":\"clusteredColumnChart\",\"projections\":{\"Y\":[{\"queryRef\":\"Sum(Pounds Poured.%Baled)\"},{\"queryRef\":\"Sum(Pounds Poured.Prediction)\"}],\"Category\":[{\"queryRef\":\"Pounds Poured.Week Number\",\"active\":true}]},\"prototypeQuery\":{\"Version\":2,\"From\":[{\"Name\":\"p2\",\"Entity\":\"Pounds Poured\"}],\"Select\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"p2\"}},\"Property\":\"Week Number\"},\"Name\":\"Pounds Poured.Week Number\"},{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"p2\"}},\"Property\":\"%Baled\"}},\"Function\":0},\"Name\":\"Sum(Pounds Poured.%Baled)\"},{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"p2\"}},\"Property\":\"Prediction\"}},\"Function\":0},\"Name\":\"Sum(Pounds Poured.Prediction)\"}]},\"objects\":{\"trend\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}}}}],\"categoryAxis\":[{\"properties\":{\"axisType\":{\"expr\":{\"Literal\":{\"Value\":\"'Categorical'\"}}},\"showAxisTitle\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}}}}],\"valueAxis\":[{\"properties\":{\"showAxisTitle\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}},\"labelDisplayUnits\":{\"expr\":{\"Literal\":{\"Value\":\"1D\"}}}}}],\"y1AxisReferenceLine\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}},\"lineColor\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#00ff4e'\"}}}}},\"value\":{\"expr\":{\"Literal\":{\"Value\":\"0.1225D\"}}},\"transparency\":{\"expr\":{\"Literal\":{\"Value\":\"0D\"}}},\"style\":{\"expr\":{\"Literal\":{\"Value\":\"'dotted'\"}}},\"position\":{\"expr\":{\"Literal\":{\"Value\":\"'front'\"}}}},\"selector\":{\"id\":\"0\"}}],\"labels\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}},\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#000000'\"}}}}},\"labelDisplayUnits\":{\"expr\":{\"Literal\":{\"Value\":\"1D\"}}},\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'11'\"}}}}}],\"dataPoint\":[{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#00ff3b'\"}}}}}},\"selector\":{\"metadata\":\"Sum(Pounds Poured.Prediction)\"}}]}},\"name\":\"VisualContainer1\"}"},{"x":783.0060934326337,"y":0,"z":3,"width":699.7291807718348,"height":330.0609343263372,"config":"{\"layouts\":[{\"id\":0,\"position\":{\"x\":783.0060934326337,\"y\":0,\"z\":3,\"width\":699.7291807718348,\"height\":330.0609343263372,\"angle\":0}}],\"singleVisual\":{\"title\":{\"text\":\"WC Pounds Poured vs Pounds Baled per Period 2016\",\"show\":true,\"fontColor\":\"#303637\",\"alignment\":\"center\",\"fontSize\":\"16\"},\"border\":{\"show\":true},\"visualType\":\"lineStackedColumnComboChart\",\"projections\":{\"Category\":[{\"queryRef\":\"Pounds Poured.Period\",\"active\":true}],\"Y\":[{\"queryRef\":\"Sum(Pounds Poured.Pound Poured)\"},{\"queryRef\":\"Sum(vwScalesDataFabricationNetValue.Pound Bailed)\"},{\"queryRef\":\"Pounds Poured.%IBsBaled\"}]},\"prototypeQuery\":{\"Version\":2,\"From\":[{\"Name\":\"p2\",\"Entity\":\"Pounds Poured\"},{\"Name\":\"v\",\"Entity\":\"vwScalesDataFabricationNetValue\"}],\"Select\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"p2\"}},\"Property\":\"Period\"},\"Name\":\"Pounds Poured.Period\"},{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"p2\"}},\"Property\":\"Pound Poured\"}},\"Function\":0},\"Name\":\"Sum(Pounds Poured.Pound Poured)\"},{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"v\"}},\"Property\":\"Pound Bailed\"}},\"Function\":0},\"Name\":\"Sum(vwScalesDataFabricationNetValue.Pound Bailed)\"},{\"Measure\":{\"Expression\":{\"SourceRef\":{\"Source\":\"p2\"}},\"Property\":\"%IBsBaled\"},\"Name\":\"Pounds Poured.%IBsBaled\"}]},\"objects\":{\"dataPoint\":[{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#0088ff'\"}}}}}},\"selector\":{\"metadata\":\"Sum(Pounds Poured.Pound Poured)\"}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#ff0a22'\"}}}}}},\"selector\":{\"metadata\":\"Sum(vwScalesDataFabricationNetValue.FabricationNetValue)\"}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#ff2824'\"}}}}}},\"selector\":{\"metadata\":\"Sum(vwScalesDataFabricationNetValue.Pound Bailed)\"}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#000000'\"}}}}}},\"selector\":{\"metadata\":\"Pounds Poured.%IBsBaled\"}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#437eff'\"}}}}}},\"selector\":{\"metadata\":\"Sum(Pounds Poured.Pound Poured)1\"}}],\"trend\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}}}}],\"categoryAxis\":[{\"properties\":{\"axisType\":{\"expr\":{\"Literal\":{\"Value\":\"'Categorical'\"}}},\"showAxisTitle\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}}}}],\"valueAxis\":[{\"properties\":{\"showAxisTitle\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}},\"labelDisplayUnits\":{\"expr\":{\"Literal\":{\"Value\":\"1D\"}}}}}],\"labels\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}},\"labelDisplayUnits\":{\"expr\":{\"Literal\":{\"Value\":\"1D\"}}},\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#000000'\"}}}}}}}]}},\"name\":\"VisualContainer2\"}"},{"x":783.0060934326337,"y":360.5280974949221,"z":1,"width":700,"height":330.0609343263372,"config":"{\"layouts\":[{\"id\":0,\"position\":{\"x\":783.0060934326337,\"y\":360.5280974949221,\"z\":1,\"width\":700,\"height\":330.0609343263372,\"angle\":0}}],\"singleVisual\":{\"title\":{\"text\":\"WC Pounds Poured vs Pounds Baled per Period 2016\",\"show\":true,\"fontSize\":\"16\",\"alignment\":\"center\",\"fontColor\":\"#303637\"},\"border\":{\"show\":true},\"visualType\":\"lineChart\",\"projections\":{\"Y\":[{\"queryRef\":\"Sum(vwScalesDataFabricationNetValue.Pound Bailed)\"},{\"queryRef\":\"Sum(Pounds Poured.Pound Poured)1\"}],\"Category\":[{\"queryRef\":\"Pounds Poured.Period\"}]},\"prototypeQuery\":{\"Version\":2,\"From\":[{\"Name\":\"v\",\"Entity\":\"vwScalesDataFabricationNetValue\"},{\"Name\":\"p2\",\"Entity\":\"Pounds Poured\"}],\"Select\":[{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"v\"}},\"Property\":\"Pound Bailed\"}},\"Function\":0},\"Name\":\"Sum(vwScalesDataFabricationNetValue.Pound Bailed)\"},{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"p2\"}},\"Property\":\"Pound Poured\"}},\"Function\":0},\"Name\":\"Sum(Pounds Poured.Pound Poured)1\"},{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"p2\"}},\"Property\":\"Period\"},\"Name\":\"Pounds Poured.Period\"}]},\"objects\":{\"dataPoint\":[{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#0088ff'\"}}}}}},\"selector\":{\"metadata\":\"Sum(Pounds Poured.Pound Poured)\"}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#ff0a22'\"}}}}}},\"selector\":{\"metadata\":\"Sum(vwScalesDataFabricationNetValue.FabricationNetValue)\"}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#ff2824'\"}}}}}},\"selector\":{\"metadata\":\"Sum(vwScalesDataFabricationNetValue.Pound Bailed)\"}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#437eff'\"}}}}}},\"selector\":{\"metadata\":\"Sum(Pounds Poured.Pound Poured)1\"}}],\"trend\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}}}}],\"categoryAxis\":[{\"properties\":{\"axisType\":{\"expr\":{\"Literal\":{\"Value\":\"'Categorical'\"}}},\"showAxisTitle\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}}}}],\"valueAxis\":[{\"properties\":{\"showAxisTitle\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}},\"labelDisplayUnits\":{\"expr\":{\"Literal\":{\"Value\":\"1D\"}}},\"axisScale\":{\"expr\":{\"Literal\":{\"Value\":\"'log'\"}}}}}],\"y1AxisReferenceLine\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}}},\"selector\":{\"id\":\"0\"}}],\"labels\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}}}}]}},\"name\":\"VisualContainer3\"}"}],"displayOption":1,"width":1500,"height":720,"config":"{}"}

 

@Lucy64

 

Can you upload the PBIX and source files that can reproduce this problem? You can upload them to OneDrive, DropBox or any other web storage and share the link. Do mask sensitive data before uploading.

CahabaData
Memorable Member
Memorable Member

please define: "pass this to another user"

 

actually sending the PBIX file?

 

 

www.CahabaData.com

Yes I emailed the PBIX file, saved to their computer then edited the source files.

I do not see an answer at the moment except that if you are sending a PBIX file, then do your really mean that the source data is linked?  Is the data not all imported into the PBIX? - that is the only thing I see at the moment.

www.CahabaData.com

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.