Format a graph in Desktop

[karkar]

Hello,

How do i have more than one line of title/subtitle working on a chart in Desktop?

I found some documentation to do the same in Power Bi service, but not in Desktop!!

Also how do i format the axis values and Legends?

https://powerbi.microsoft.com/en-us/documentation/powerbi-service-tutorial-customize-visualization-t...

[parry2k]

Did you look at this link for legends and axis values?

I don;t think you have sub title in desktop

[karkar]

Hello Parry, Thanks for the reply.

SO WE CAN ONLY DO THAT IN power BI SERVICE AFTER PUBLISHING AND NOT ON THE DESKTOP? AM I CORRECT?

[karkar]

Also , If i am working on a trend chart -on the the X-axis if I am looking at Days

Jan1  Jan2    Jan3   Jan4 Jan5 and so on....How do I make all the values on the X-axis to show up on the graph... Currently it only has few of them like      Jan1   Jan3   Jan5

[parry2k]

Yes subtitle is only in app.powerbi.com, to see all dates, do you have calendar table with continuous dates in it. Also you need to change the type for X-Axis to "Continuous"

[karkar]

Hello Parry, It is already pre selected as continuous.....but not giving me the continuous x-axis values on my chart!!

Currently it says    DEC25          JAN01        JAN08.

The trend chart is continuous (has data for DEC26th and so on) but the x-axis values does not have DEC26...

Thnaks

[parry2k]

Can you confirm you have calendar table with continuous dates in it?

If not then we can create one and link your data table to calendar table and then use date from calendar table on x-axis

[karkar]

Hello Parry, when you metioned calendar table is it seperate from my data table?I am working just with my data. Do i need to create one?

Thanks

[parry2k]

It is always good practice to have a continuour date (calendar table), based on your input, seems like you don't have one.

if you are ok, send me your email in private message, i will share a pbix file wiht you, which will have calendar table and help you understand how it will work with your data.