Forum Discussion
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
please define: "pass this to another user"
actually sending the PBIX file?
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.
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.
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:
Cannot read property 'window' of undefined
Recent Actions
RemoveProjection, VisualConversion, VisualConversion, VisualConversion, AddFieldInRole, RemoveProjection, AddFieldInRole, VisualConversionActive 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":"{}"}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.
