Forum Discussion

jacobvz's avatar
jacobvz
New Member
5 years ago
Solved

Overlay target data in visualization

Hi All, I was asked to create a PowerBI report that shows numbers of occurences for a category per month and totals for that month as well (see visualisation below)   As this required the ...
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi jacobvz ,

    "issue is not so much an error message but when I copy the link to the workbook and want to use it in a report by using the link to the excel file it shows me a blank screen"

    You cannot use the web link which directs to the excel file in power service to connect it in power bi desktop. As you mentioned, store it in the cloud source and configure gateway for it is optional and available.

     

    "I tried converting the excel to a powerbi dataset but when I try to use it in the report I get the message that the report is already using another dataset (which is correct, I do)"

    To connect to power bi datasets in power bi desktop, the connection mode is Live Connection which only allows just one data source to connect in power bi.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

jacobvz's avatar
jacobvz
New Member
5 years ago

Hi 

I have taken your advise and created this. Thank you

 

 

Sofar the request was monthly onlyso I think we are good on that..I can make the line same as background colour and just leave the marker. Can we customize the marker?

 

Finaly we like to give the user access to modify the targets so I used an excel spreadsheet as the datasource. but when I upload this to app.powerbi.com i seem to have issues connecting to the excel file.

when I change the datasource in the report from local file to the saved link for the file online I get message that it is receiving html.

v-yingjl's avatar
v-yingjl
Community Support
5 years ago

Hi jacobvz ,

You can select different markers in the Shape tab when you enable 'Show markers' in the chart:

When you upload to power bi service, you have faced with issues. Did it have any error messages and could you please consider sharing the error message or screenshots about it for further discussion?

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • jacobvz's avatar
    jacobvz
    New Member
    5 years ago

    I replied to the wrong post..I responded to your post above your post 🙂