Solved: Dynamic Visual size with addition of data into the...

Rabi · ‎09-20-2023

Hi Everyone,

Is there a way to make the visual size adjust with addition of data in the visual. I had a BarCharts visual built, the data in the visual updates on fortnightly basis and the bars increase. Lately I need to scroll the visual to view the complete data in the chart.

Is there any way to make this adjustment dynamic.

Regards,

Rabi

@parry2k

parry2k · ‎09-20-2023

@Rabi on the format pane what is the x-axis type, is it continuous or categorical? If the column used on the x-axis is number or date type then if you change the type to continuous you will not have this scroll bar.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

parry2k · ‎09-20-2023

@Rabi on the format pane what is the x-axis type, is it continuous or categorical? If the column used on the x-axis is number or date type then if you change the type to continuous you will not have this scroll bar.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Rabi · ‎09-20-2023

Yeah, it works and I had already tried it, the idea was to have a complete date, however it's ok for now.

Thanks!!

parry2k · ‎09-20-2023

What is on x-axis? If. It is date or number columns, it will fit otherwise not.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.