In this Blog, I will show you How to select Max Date and Max Time for the Date. I have this kind of table: CREATE TABLE Dateandtime1( [Date_updated] [date], [Time_updated] [Time] ) We can create two columns that have both date and time…
Still haven’t empowered your business with Microsoft Power BI? Hurry up! Microsoft Power BI is a set of Business Intelligence tools used by organizations to help them gather important data, visualize and analyze it to form creative and understandable reports for decision-making. Power BI is…
Hi Readers , have you ever wondered on how to run a Machine learning Model (in python) in Powerbi application? This Blog will help you with it.Before Implementing it you need to have a ML model in python code ready. In my case, I have…
Alerts and Notification are great features provided by Microsoft Power BI for their report users. You will get an alert or notification when the value goes above or below the threshold. You can use these features on KPI, Cards, and Gauge visuals on Power BI…
I worked on a dataset connected through Web API. Multiple tables are appended and used in the report. I got the below mentioned error while refreshing manually and scheduled in Power BI service, but it is refreshed in power BI desktop without any error. Processing…
This is a small blog explaining the DAX expression to count multiple column values into a single column. Here we have a sample table Table1, which has columns named ID, Dim1, Dim2, Dim3 and Dim4. The columns Dim1 to Dim4 has the values “Yes” or…
The Drillthrough feature in Power BI functions as an indicator for a Power BI Report. With Drillthrough in power bi report, you can create a destination target page in your report. When report viewer right-click a Data point in other pages, they drillthrough automatically filtered to…
In this blog I will show you how you can set format for hierarchical axis labels on chart in good way, also we will see how concatenate labels property will help us to achieve this Issue with multi-Axis/ Hierarchical axis.In below Image there are 3…
The COVID 19 pandemic has affected the entire world on huge masses. It has not yet been controlled by the governments as the on-going spread of its variants is the main concern. Tools like Power BI have not only helped the professionals to build in…
Hi everyone, in this blog we are going to learn about different types of Analytical lines in PowerBI. Let’s get started. We have a data which talks about Sales of Various different products. You shall see a glimpse of it down below: Our objective is…
