cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Microsoft
Microsoft

dynamic visualizations

Hello,

 

Can i know if power BI supports the following

  • ability to automatically change visualizations/flags on dashboards/reports when we have data issues? (ie say an icon resource type/link is read from data (ex SQL table)  and the table stores the data state)
  • tooltips on tiles (with custom text) so we can call out data issues?

 

Thanks!

 

 

 

1 REPLY 1
Highlighted
Power Participant
Power Participant

Re: dynamic visualizations

For the first point: Power BI can read data from a SQL table and present it. OOB you could use the KPI visual and set up the Target goals so the text changes to red when "data issues" exceed a tolerable count.  There are alternative visuals that might suit in the Custom Visuals Gallery e.g. Synoptic Panel, Table Heatmap.

 

For the 2nd point: This level of control of tooltips isnt available AFAIK. I would add a Table or Long Text (Custom Visual) and shrink the height to a single line, perhaps at the bottom of the page.  The data table fed in would be rows of data issues, with a default single row showing "No current data issues".  If there were "data issues", I would set up the dataset so the first row shows something like "NNN data issues detected - click Focus mode to review".  When the user clicks "Focus mode" on that vis it will zoom up to full screen and show all the rows of data fed in, with a scroll bar if necessary.  This is probably more practical functionality than a tooltip.

Helpful resources

Announcements
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Kudoed Authors