fbpx

About pleblanc

This author has not yet filled in any details.
So far pleblanc has created 178 blog entries.

What’s this Power BI report filtered by???

Struggling with understanding what is filtering your visual or Power BI report? Patrick walks you through how you can tell what is going on. SQLBI Filter Context: https://www.sqlbi.com/articles/displaying-filter-context-in-power-bi-tooltips/

What’s this Power BI report filtered by???2021-10-27T06:23:25-05:00

RLS with TWO Fact tables in Power BI

Have you struggled with using Row-Level Security (RLS) on a dimension connected to two fact tables? Patrick looks at some options you can use to accomplish this in Power BI.

RLS with TWO Fact tables in Power BI2021-10-13T07:43:27-05:00

How to show 5 minute intervals in Power BI?

Another question from the comments... MrTavelBlog wanted to know how to show 5 minute intervals in Power BI. Patrick accepts the challenge and shows you how! Power BI date table: create using DAX https://www.youtube.com/watch?v=gyvhM5eiT0U Working with time in Power BI Desktop https://www.youtube.com/watch?v=8DFih8ccMV0 Create Buckets or Groups with Power Query in Power BI https://www.youtube.com/watch?v=D1LO8syugMA

How to show 5 minute intervals in Power BI?2021-10-06T06:33:06-05:00

Finding the lowest value and highlighting in DAX | Power BI

Sometimes you want to highlight the lowest value in a Power BI visual. First you need to find it! Then you can highlight it. What if you want to ANIMATE it? Patrick shows you how to do just that! ALLSELECTED() article: https://www.sqlbi.com/articles/the-definitive-guide-to-allselected/

Finding the lowest value and highlighting in DAX | Power BI2021-09-29T07:09:46-05:00

One Click Calculation Group in Power BI

Calculation Groups in Power BI can be amazing! Patrick shows you how you can create these common patterns with just one click using Tabular Editor. Blog: https://www.esbrina-ba.com/time-intelligence-the-smart-way/ Calculation Groups: https://docs.microsoft.com/analysis-services/tabular-models/calculation-groups?view=asallproducts-allversions Tabular Editor: https://tabulareditor.com

One Click Calculation Group in Power BI2021-09-22T04:57:40-05:00

How to show a name more than once in Power BI

Ever run into an issue where a duplicate name doesn't show up? Is it being aggregated? Patrick looks at a few ways you can avoid the duplicate name from disappearing in Power BI.

How to show a name more than once in Power BI2021-09-15T06:10:26-05:00

When is a date not a date in Power BI?

When is a date not a date? We all use them in our data. Patrick looks at how data types can be a tricky thing in Power BI. Be aware of what you are working with in order to avoid this problem in your charts.

When is a date not a date in Power BI?2021-09-08T06:12:22-05:00

CRUSHING requirements with Small Multiples in Power BI

Check out how using Small Multiples in Power BI can help you CRUSH requirements and satisfy business requests to make amazing reports! Patrick also has a neat trick for you. Documentation: https://docs.microsoft.com/power-bi/visuals/power-bi-visualization-small-multiples

CRUSHING requirements with Small Multiples in Power BI2021-09-01T05:21:17-05:00

Can you refresh a single table in Power BI?

Frustrated that a you can only do a full refresh? Patrick takes it to the next level by showing how you can refresh only a single table in your Power BI dataset. This is a great option for targeted refresh and avoid potential overhead. Processing Options: https://docs.microsoft.com/analysis-services/multidimensional-models/processing-options-and-settings-analysis-services?view=asallproducts-allversions Refresh Types: https://docs.microsoft.com/azure/analysis-services/analysis-services-async-refresh Elegant BI Blog: https://www.elegantbi.com/post/datarefreshintabulareditor https://www.elegantbi.com/post/processingmanager

Can you refresh a single table in Power BI?2021-08-18T07:10:04-05:00
Go to Top