'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Create a Scrolling News Headline Visual with Hover Details in Power BI
Question details
The user needs to create an auto-scrolling news ticker from a database that displays the full text body upon hovering, ideally without purchasing any custom visual licenses.
- Product
- Microsoft Power BI
- Device & OS
- not provided
- Scenario
- Designing a dynamic dashboard report that features live, auto-scrolling news headlines and interactive hover tooltips.
- Observed behavior
- Built-in Power BI visuals and standard DAX do not natively support animated scrolling marquees, meaning a specific custom visual or community workaround is required to achieve this layout.
Verify that your Power BI Desktop is updated to the latest version and that your organization's tenant settings allow the importation of third-party custom visuals from the AppSource marketplace.
Utilize Free AppSource Visuals and Report Page Tooltips
Since native DAX cannot animate text, utilizing a free custom visual from AppSource combined with native Report Page Tooltips is the most effective approach.
Power BI does not feature a built-in scrolling marquee visual. To accomplish this without paying for a license, you can search Microsoft AppSource for free tier visuals like the 'Scroller' and pair it with Power BI's built-in custom tooltip pages.
Open Power BI Desktop, navigate to the Visualizations pane, click the three dots (...) icon, and select 'Get more visuals'. Search for 'Scroller' or 'Ticker' in the AppSource window and add a free option to your report.
Add the newly imported visual to your report canvas and drag your database's news headline column into the appropriate category or text field of the visual.
Create a new page in your report. Go to the Format pane for the page, expand 'Page Information', and toggle 'Allow use as tooltip' to On. Design this page to display your full news body field.
Return to your main report page containing the scrolling visual. In its Format pane, locate the 'Tooltip' section and change the type to 'Report page', then select the tooltip page you just created.
Consult the Official Power BI Community for HTML Workarounds
If marketplace visuals do not support hover states exactly as required, specialized community workarounds using HTML viewer visuals and DAX measures may be necessary.
Streamline Your Daily Data Reporting with WPS Office
While Power BI excels at building complex, interactive business intelligence dashboards, you often need a lightweight, cost-effective tool for everyday data analysis and reporting. WPS Office offers a highly compatible, free alternative to Microsoft Office, featuring robust spreadsheet capabilities for all your daily data tasks.
Frequently Asked Questions
Can I create a scrolling text marquee using only standard DAX?
No, DAX is a query and formula language meant for calculations. It cannot generate dynamic UI animations like scrolling text on its own. You must use a visual component to handle the animation layer.
How do I show full text details when hovering over a visual?
You can use Power BI's Report Page Tooltips feature. By designing a custom tooltip page and assigning it to your main visual's properties, you can display the full news body when a user hovers over a specific headline.
Are there free custom visuals for scrolling text in Power BI?
Yes, the Microsoft AppSource marketplace offers custom visuals like the 'Scroller' by MAQ Software. However, you must verify if the specific visual supports custom report tooltips and remains free for your organization's required use case.
