cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vanessafvg
Super User
Super User

Fit Entire View of data visual to page

In Tableau you can fit an entire view of the data into a visual without scrolling, so if i have for example a line graph that spans over a period of time if that view gets too big power bi will enable a scroll bar, i dont want the scroll bar i just want the whole view to be squashed into the visual size.

 

Is there a way of doing this in Power BI?





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




1 ACCEPTED SOLUTION
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @vanessafvg,

 

By my tests, I'm afraid that we may not achieve your requirement in Power BI currently.

 

You could submit your idea in Power BI ideas Forum.

 

The workaround of DAXRichArd may help you.

 

Best Regards,

Cherry

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

View solution in original post

6 REPLIES 6
echevtchenko
New Member

Hi,

Found this fix:

If you click outside your active visual (in the white space to the side of the dotted frame) and then go to format > page size > custom, you can specify any size for you page effectively zooming in and out on your visual. 

 

Original source: nate chamberlain com 2018 03 06 how to change power bi report page size (linking gave a invalid html error message =/ 

v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @vanessafvg,

 

By my tests, I'm afraid that we may not achieve your requirement in Power BI currently.

 

You could submit your idea in Power BI ideas Forum.

 

The workaround of DAXRichArd may help you.

 

Best Regards,

Cherry

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

Hi, you need to format your visual.

Select then, go to format(in the right panel), X-Axis, and in type change categorical to continuous
Screenshot_2.png

 

If it solve your problem, please mark as solved and give your positive feedback.

Rafael Mendonça
MCSA Bi Reporting
www.youtube.com/rafaelmendonca

@rafaelmpsantos the problem continious is its not displaying the data the way we want it to so that doesn't solve the problem





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Hello,

You may have to reduce your granularity on the time series axis (x-axis). For example, I use very long time series data extending 10 to 15 years. If I use a monthly view, it does not fit, to I have to annualize the data in my visual in order to get everything to fit without showing a scroll bar. Not sure if this is the solution you seek but this is my work around.

@DAXRichArd makes sense but unfortunately the issue isn't the years!





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors