BI-Lingual Analytics
  • Home
  • Blog
  • About Me
  • Contact Us

bilinguala

Visualisation

Heatmap Visual In Power BI

Part II – How To “Beautify” The Heatmap Matrix Visual in Power BI In the previous tutorial (Part I) we have covered how to use the built-in matrix visual in Power BI to create a heatmap data visualization. It relies on the option to conditionally format the cell background colour Read more…

By bilinguala, 2 years2 years ago
Visualisation

Heatmap Visual In Power BI

Part I – How To Create a Heatmap Data Visualisation Based On a Ticketing System If you prefer to watch a video tutorial please scroll down to the bottom of the page ⤵️ What Prompted The Idea? Well, I was walking past a Post Office when I saw the below Read more…

By bilinguala, 2 years2 years ago
Dataflow

Calendar Tables In Power BI Dataflow

If you are about to start your journey with Power BI Dataflow, I suggest developing a standard calendar or date table that everyone within the organization can use. Power BI Dataflows are all about reusing clean and pre-approved data, so having a company-wide approved calendar table to use in reporting Read more…

By bilinguala, 3 years3 years ago
Tips&Tricks

Dynamic Field Parameter Grouping

Sometimes it is not too efficient to manually adjust the DAX code of the Field Parameters and create a column for grouping. Let’s say when you have more than 8-10 fields, you are probably better off with some dynamic grouping. One of the easiest (and probably best) ways to do Read more…

By bilinguala, 3 years3 years ago
Tips&Tricks

RLS On Field Parameters

With the introduction of Field Parameters in Power BI, report creators were given a tool to provide a better User Experience in reports. But with great powers comes great responsibility… In other words, if you add lots of fields to the Parameter Table in Power BI it will be difficult Read more…

By bilinguala, 3 years3 years ago
Tips&Tricks

Group Field Parameters

With the introduction of Field Parameters in Power BI, report creators were given a tool to provide a better User Experience in reports. But with great powers comes great responsibility… In other words, if you add lots of fields to the Parameter Table in Power BI it will be difficult Read more…

By bilinguala, 3 years3 years ago
Tips&Tricks

Date Tables in Power BI

Full Calendar vs Trimmed Calendar We all know that having a Date Table in Power BI is a must to achieve reliable and good Time Intelligence functions and measures. But did you know that these measures could work with both a Full Calendar and a Trimmed Calendar? In today’s video, Read more…

By bilinguala, 3 years3 years ago
Dataflow

Troubleshooting Dataflows

What options do you have when something goes wrong with a Dataflow in Power BI? Well, there are quite a few options to use and each offers a different way of handling problems. If you want to learn more check out the below tutorial 👇👇👇 Roland 🙏Thanks for watching and Read more…

By bilinguala, 3 years3 years ago
Tips&Tricks

Custom Sort Order in Power BI

Today I would like to present two “issues” that I reckon many of you faced before. The first one is sorting month names chronologically in a custom Calendar/Date table, and the second one is sorting customers based on a custom sort order. So, you have followed a Power BI Best Practice Read more…

By bilinguala, 3 years3 years ago
Visualisation

Hotspots In A Shopping Centre

Today I am going to tackle a problem that doesn’t involve sales-related data. Why? Because not all Power BI reports should be about sales figures. Let’s say that I am the owner of a popular mall here in Sydney. One of the many features of a shopping centre is those Read more…

By bilinguala, 3 years3 years ago

Posts navigation

1 2 … 7 Next
  • About Me
  • Asus ROG STRIX GAMING OC GeForce RTX 3080 12GB
  • Blog
  • Contact Us
  • Gigabyte AORUS MASTER GeForce RTX 3080 12GB
  • Home
2020 | Powered by Renata Szijarto
This website uses cookies to improve your experience. We'll assume you accept this policy as long as you are using this websiteAcceptView Policy