Forum Discussion

pey's avatar
pey
Frequent Visitor
4 years ago

plotting data on secondary axis using single set of data

Hi,

 

I have a set of data with 5 variables and each differ in terms of order of magnitude. For instance, variable A is in the range of 100 while variable B is the range of 10,000 etc. All data are categorized into 3 columns ( Column 1= date, Column 2 = variable name, Column 3= value). I reazlied that I am not able to plot variable A in main Y-axis and B in secondary axis... as the filtering function will work on the whole dataset. Is there anyway around this? 

 

Thank you. 

Need Help
Show and Tell

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    pey , You can not use the legend on the secondary axis as of now, if that is the need.

     

    You can check for custom visual

  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, pey 

     

    Can you provide a simple PBIX file for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures. I look forward to your response.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

  • radhey_rec's avatar
    radhey_rec
    Icon for Resolver II rankResolver II
    4 years ago

    Hi pey 

     

    Can you please give a screenshot of the chart (pen and paper chart will do) along with the data that is necessary to create it?

    May be, I can help you out to create the visual you want using https://pbivizedit.com service?

     

    Thanks,

    Radhey