cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lucy64 Regular Visitor
Regular Visitor

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
CahabaData New Contributor
New Contributor

Re: Line and clustered column chart error

please define: "pass this to another user"

 

actually sending the PBIX file?

 

 

www.CahabaData.com
Lucy64 Regular Visitor
Regular Visitor

Re: Line and clustered column chart error

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

CahabaData New Contributor
New Contributor

Re: Line and clustered column chart error

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
Moderator Eric_Zhang
Moderator

Re: Line and clustered column chart error


@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?

Lucy64 Regular Visitor
Regular Visitor

Re: Line and clustered column chart error

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":"{}"}

 

Highlighted
Moderator Eric_Zhang
Moderator

Re: Line and clustered column chart error

@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.

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 395 members 3,386 guests
Please welcome our newest community members: