Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
i have a "line and stacked column" visual with bars and a line. When publishing this visual to powerbi online a dotted line s howing the average for my line value shows up. This does not show up in desktop and i can't even check to make sure the analytics line is disabled because this visual doesn't actually support it. So how am i getting the dotted line when publishing?
Solved! Go to Solution.
ok i fixed the issue. Apparently you can force a trendline on in your custom theme which i had done. removing the following code from my theme fixed this:
{ "name": "7 Color Theme", "dataColors": [ "#8AD4EB", "#e6e6e6", "#eb8a8a", "#ebaf8a", "#f4eb95", "#a8e098", "#9DEDCC", "#BEC0DB" ], "background": "#FFFFFF", "foreground": "#000000", "tableAccent": "#000000", "visualStyles": { "visualName": { "styleName": { "cardName": [ { "propertyName": "propertyValue" } ] } }, "*": { "*": { "*": [ { "fontSize": 8, "fontFamily": "Segoe UI" } ], ... ### PROBLEM CODE IS HERE ### "trend": [ { "show": true } ], ### PROBLEM CODE IS HERE ... } }, "areaChart": { "*": { "legend": [ {} ], "categoryAxis": [ {} ] } } } }
ok i fixed the issue. Apparently you can force a trendline on in your custom theme which i had done. removing the following code from my theme fixed this:
{ "name": "7 Color Theme", "dataColors": [ "#8AD4EB", "#e6e6e6", "#eb8a8a", "#ebaf8a", "#f4eb95", "#a8e098", "#9DEDCC", "#BEC0DB" ], "background": "#FFFFFF", "foreground": "#000000", "tableAccent": "#000000", "visualStyles": { "visualName": { "styleName": { "cardName": [ { "propertyName": "propertyValue" } ] } }, "*": { "*": { "*": [ { "fontSize": 8, "fontFamily": "Segoe UI" } ], ... ### PROBLEM CODE IS HERE ### "trend": [ { "show": true } ], ### PROBLEM CODE IS HERE ... } }, "areaChart": { "*": { "legend": [ {} ], "categoryAxis": [ {} ] } } } }
i dont see a way to upload a PBIX file here.
I also just uninstalled and reinstalled PowerBI Desktop (from the windows store). Now it's also showing a trendline in Desktop even though it's not possible for that visual. It still works fine if i refert to a default theme instead of my custom theme
@v-peken,
I am unable to reproduce this issue by using the above report theme in my PBIX file. Would you mind sharing me a PBIX file containing dummy data? I will test it in my environment.
Regards,
Lydia
It seems to be an issue with my custom theme as this doesn't occur when switching back to default theme. below is the json theme i'm using. Is there anything in there that would cause this?
{ "name": "7 Color Theme", "dataColors": [ "#8AD4EB", "#e6e6e6", "#eb8a8a", "#ebaf8a", "#f4eb95", "#a8e098", "#9DEDCC", "#BEC0DB" ], "background": "#FFFFFF", "foreground": "#000000", "tableAccent": "#000000", "visualStyles": { "visualName": { "styleName": { "cardName": [ { "propertyName": "propertyValue" } ] } }, "*": { "*": { "*": [ { "fontSize": 8, "fontFamily": "Segoe UI" } ], "general": [ { "responsive": true } ], "legend": [ { "show": true, "position": "Top", "showTitle": true, "labelColor": "#00ff00", "fontSize": 8 } ], "categoryAxis": [ { "show": true, "showAxisTitle": false, "labelColor": "#737373", "fontSize": 10 } ], "valueAxis": [ { "show": true, "position": "left", "showAxisTitle": false, "labelColor": "#737373", "fontSize": 10, "secShow": true, "secPosition": "right", "secShowAxisTitle": false, "secLabelColor": "#737373", "secFontSize": 10 } ], "labels": [ { "show": true, "percentageLabelPrecision": 2, "labelDensity": 100 } ], "lineStyles": [ { "strokeWidth": 2, "lineStyle": "solid" } ], "plotArea": [ { "transparency": 50 } ], "trend": [ { "show": true } ], "categoryLabels": [ { "show": false } ], "wordWrap": [ { "show": false } ], "dataLabels": [ { "show": true, "fontSize": 20 } ], "cardTitle": [ { "color": "#737373", "fontSize": 12 } ], "card": [ { "barShow": true, "barColor": "#999999", "barWeight": 3, "cardPadding": 10 } ], "percentBarLabel": [ { "fontSize": 10 } ], "target": [ { "show": true, "fontSize": 10 } ], "calloutValue": [ { "show": true } ], "grid": [ { "outlineColor": "#000000", "gridVertical": false, "gridVerticalColor": "#f5f5f5", "gridHorizontal": false, "gridHorizontalColor": "#f5f5f5", "rowPadding": 3 } ], "columnHeaders": [ { "outline": "BottomOnly", "wordWrap": false, "urlIcon": true } ], "values": [ { "outline": "none", "backColorSecondary": "#f5f5f5", "urlIcon": true, "wordWrap": false } ], "total": [ { "outline": "TopOnly" } ], "selection": [ { "selectAllCheckboxEnabled": true, "singleSelect": false } ], "header": [ { "show": true, "outline": "BottomOnly", "textSize": 10 } ], "items": [ { "background": "#ffffff", "textSize": 9 } ], "sentimentColors": [ { "increaseFill": "#ff0000", "decreaseFill": "#00ff00", "totalFill": "#0000ff", "otherFill": "#aaaaaa" } ], "trendline": [ { "show": true } ], "goals": [ { "showGoal": true, "showDistance": true } ], "status": [ { "goodColor": "#00ff00", "neutralColor": "ffff00", "badColor": "ff0000" } ] } }, "areaChart": { "*": { "legend": [ {} ], "categoryAxis": [ {} ] } } } }
pbi online/desktop screenshots. I do import a custom theme if that might impact it. I use the most recent PBI Desktop version 2.59.5135.421 64-bit (June 2018)
@v-peken,
I am unable to reproduce this issue using my PBIX file. What version of Power BI Desktop do you use?
Could you please share a screenshot and share PBIX file containing dummy data here?
Regards,
Lydia
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
71 |