This is a very short, simple article about how to have a multi-select slicer in Power BI. Power BI slicer is in fact multi-select by default, however, there is a very small option that if you set it, makes it even easier to use, let’s talk about it. If you want to learn more about Read more about Multi-Select Slicer in Power BI[…]
Power BI has some built-in, easy-to-use DAX functions to get the Day of Month and Day of the week, but nothing for Day of Year and Day of the quarter. These calculations, however, are very simple and easy to implement using other functions. This short blog and video explain a method to calculate those for Read more about Day of Year and Day of Quarter – DAX calculations for Power BI[…]
Relationships are the heart of Power BI modeling, and Power BI Desktop has a way to help and identify the relationships based on the source, or the data. However, often, this ability to automatically detect a relationship is more troublesome than helping, especially when you deal with tables that are not designed for reporting. In Read more about Power BI Design Tip: Disable the Auto-Detect Relationship[…]
Often you do the transformation in Power Query using the graphical interface, but having the formula bar visible, makes it much easier to understand or change the transformations. In this short blog and video, I’ll explain that. Power Query transformations In Power BI, we use Power Query a lot for transformations, but mostly using the Read more about Power BI Quick Tip: the Formula Bar in Power Query[…]
I have previously explained a number of use cases for dataflows. One really useful case for it is to use dataflow for slow data sources. In this short article and video, I’ll explain how this works. What is a dataflow? Dataflow is a Power Query process that runs in the cloud and stores the result Read more about Dataflow: a remedy slow data sources in Power BI[…]
It is not possible to change a linked entity in a dataflow in Power BI. Linked entities has to be modified only in the dataflow in which they are created. However, sometimes, you need to do a small modification to the linked entity in a chained dataflow. There is a very simple trick, In this Read more about How to modify a linked entity in Power BI dataflows[…]
Self-service BI! This is what Power BI is all about for business users. They can connect to any available data source and start creating their own reports. However, great Power (BI) comes with great responsibility as per Uncle Ben and not sure business users are aware of their responsibilities when it comes to Power BI Read more about How to stop your Power BI tenant becoming a dataset swamp?[…]
In the previous article and video, I explained a method that you can use to have real-time calculations in a Power BI streaming dataset. The calculations done that way are limited though because it is using the Q&A feature of Power BI. If you are after a complex calculation then DAX can definitely help. In Read more about Writing calculations on a real-time streaming Power BI dataset using DAX measures[…]
If you use a streaming dataset in Power BI, you cannot download the Power BI file, and you cannot open it using Power BI Desktop. This means that you are limited not to use calculations in a streaming dataset. However, there is a small trick which you can use and can be helpful. I will Read more about How to write simple calculations in a Power BI streaming dataset?[…]
Happy New Year. We wish this be a year full of happiness and joy for all of you. We are glad to let you know that version 12 of Power BI Helper is now available to download with the below new features; Detecting the storage mode of tables (DirectQuery, Dual, Import) Detecting the connection mode Read more about Power BI Helper Version 12 (2021) Feature Summary[…]