John Liu Blog

Every drop counts

Power BI Embed Report in Application

This is a testing embed report with hidden filter: To hide the filters pan, clck on the eye icon aside the Filters header. The eye icon to hide individual filter doesn’t appear to be working in embed mode, until the entire filter pan is hidden. Following is the url with filter format URL?filter=Table/Field eq 'filter value' URL?filter=Table/Field in ('value1', 'value2') With ifram embeding, you will need to use &$ instead of ?

Posted by John Liu Thursday, September 21, 2023

Power BI Auto Select KPI using Field Parameter

(Note: at time of this post, both Field parameters and New card visual are still in preview. To use these two functions, go to File –> Options and settings –> Options –> Previw features, and turn on these features.) You might need to develop Power BI KPI report for different department/user with same visual format but different data. For example, a report with some card visual and line chart for different but targeting different KPI measures.

Posted by John Liu Sunday, September 17, 2023

Power BI Page Navigation

For page navigation button, we can’t set icon as with normal button. However, if we add the icon as part of the page name, the button will show on the navigation button. To add an icon to the page name, hold Windows logo key + period (.) key. This will open the emoji window for you to pick an emoji icon. Apart from the Window emoji, you may find icons from unicode-table or vertex42

Posted by John Liu Sunday, September 17, 2023

Power BI Smart Axis

When developing Power BI report with date slicer, the large date range might make the visual overwhelming if the X axis interval is on a fix date/week/month/quater interval. It would be helpful if the X axis can auto adjust the interval betwee date/week/month/quater/year. Assumed you have a date table dimDate in your report. We can add another AutoPeriod table (in Model View –> click on New table) to define the possible intervals for the axis:

Posted by John Liu Sunday, September 17, 2023

FEATURED TAGS
ai api automation azure azure cosmos db azure openai azure vm base64 dax docker excel execution plan hyper-v infrastructure m machine learning machine learning services network network card performance power automate power bi power bi report tricks power query powershell python qgis query performance regex replication snowflake sql sql script sql server sql server admin sql server config ssl ssms troubleshooting unicode vmware