fbpx

About pleblanc

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

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

Exploring the Visio visual in Power BI

Want to explore locations with data? The Visio visual in Power BI helps you do just that! Patrick looks at how to set it up and help use your data to highlight areas within a Visio diagram. Documentation: https://support.microsoft.com/office/add-visio-visuals-to-power-bi-reports-4f09be62-f436-45c2-93b0-4a0f66b1f5a7 Download Sample

Exploring the Visio visual in Power BI2021-08-11T08:33:37-05:00
Go to Top