Dynamically display tasks in Power BI. Tricky tasks sometimes can be solved easier than you can imagine, with little DAX magic!
In result to this we will have a idea about KPIs, Tables and how to work with real business data visualization but for that lets start with the brief of PowerBI.
Enhance your Power BI report with new slicing options. Using custom visuals in Power BI report creation gives you a perfect opportunity to extend built-in visual capabilities above and beyond.
In this article, I will show you how these joins can be done using Power BI’s Power Query and also in R using dplyr.
Charticulator. Microsoft Research has quietly open-sourced a game-changing visualization platform
The error message above indicates I have a null value but Power Query was unable to convert it into logical values. When a model doesn’t load, here is what to do
In this article, I’ll show you how to create a calendar table in M (Power Query) and in DAX.
Real Time Data Streaming in Power BI with Azure. Create a seamless real time Power BI Dashboard with Azure. This course will teach you how to use Azure services for real-time data analysis, and how to use the built-in streaming visualization in Power BI.
In this article, I want to go more in-depth on the DirectQuery option, as I have a feeling that this option is still underused (for good or for bad, we’ll try to examine in this article).
Override date filter in Power BI. Overriding standard date filtering in Power BI can be trickier than you can imagine.
Go, get’em, Sherlock! Doing Data Profiling in Power BI like a PRO. Being a “data-detective” doesn’t sound appealing to you? Check why you should reconsider your stance
This article will discuss how to build a network graph for SQL relational data stored in SQL Server. It may be of interest to folks (e.g. software engineers, data engineers, database administrators) who want to take on some data science projects.
Check important differences between implicit and explicit measures in the Power BI data model, and why you should consider avoiding the easier path. I will focus solely on Measures, and try to explain in-depth the difference between explicit and implicit measures.
Build PRO Slicer pane in Power BI. Bring your Power BI report users a whole new experience with a custom-made interactive slicer pane
Push Card visuals to a new level in Power BI. Bring new life to traditional Power BI visuals and learn how to achieve expand/collapse functionality with a simple workaround
How I speed up my Power BI report 5x! Your Power BI report is slow? Check how you can dramatically speed it up applying some simple tricks while preserving the original report look
Role-playing dimensions in Power BI. Check this simple modeling technique to avoid data model redundancy
Safe click trick in Power BI. Want to avoid annoying bookmarks “on-click” behavior? Check this simple trick for “safe click”!
Functions in Power BI. Power Query is the main tool I use for this. I’ll be writing more about Power Query in the future.
I will here explain how to create your own Covid-19 Live Dashboard with all steps. On Power BI itself we will do the cleaning and importing of the data with use of DataFlow function.