Calculate the Rows Count, Ignoring Filters In Power BI

In this article, I will show How to

Calculate the total rows, Ignoring Filters In Power BI

Calculate the total rows, Ignoring Filters In Power BI


Scenario

In Power BI, I have a “Projects” table as SQL data source, I would like to show

  • The total number of rows, ignoring the filter.
  • The total number of rows, depending on the filter.

As below shown,  Continue reading “Calculate the Rows Count, Ignoring Filters In Power BI”

Advertisements

Count Blank Values In Power BI

In this article, I will show How to

Count Blank (NULL) values In Power BI Chart

Count Null values in Power BI Chart


Scenario

In Power BI, I have a data source from SQL Server Table that contains a field called “Project Status“.

The “Project Status” is not a mandatory field so it may hold a Blank or NULL value.

In Power BI, I have added a chart to show the count of “Project Status” values with the default configuration as below:

  • In Legend: Project Status.
  • In values: Count of Project Status.

Unfortunately, the configured Chart didn’t show the “No Date Items” as shown below

Show items with no data in Power BI

Continue reading “Count Blank Values In Power BI”

Install and Configure Power BI Report Server

In this article, I will show How to

Install and Configure Power BI Report Server Step By Step

Install and Configure Power BI Report Server


What’s the Power BI Report Server?

Continue reading “Install and Configure Power BI Report Server”

Power BI: We couldn’t connect to the Analysis Services server. Make sure you’ve entered the connection string correctly

In this article, I am going to solve the below issue:

We couldn’t run the report because we couldn’t connect to its data source. The report or data source might not be configured correctly.


Scenario

In Power BI Report Server, although I can browse the report properly in Power BI Desktop.

But when I tried to browse the newly published report from the Power BI Web Portal, I got the below error:

We couldn’t connect to the Analysis Services server. Make sure you’ve entered the connection string correctly.

We couldn't run the report because we couldn't connect to its data source. The report or data source might not be configured correctly. Continue reading “Power BI: We couldn’t connect to the Analysis Services server. Make sure you’ve entered the connection string correctly”

Selection Pane Features In Power BI

In the previous “Bookmarks Pane Preview feature” article, I have explored the bookmarks feature that introduced in Power BI October 2017 update.

In this article, I will continue exploring another new amazing reporting feature that is

The Selection Pane In Power BI.


Selection Pane In Power BI

Selection Pane is a new reporting feature that announced in Power BI October 2017 update.

It’s an amazing feature specifically for complex Power BI reports with many overlapping objects. it lists all the visualization parts in the current report page and allows you to hide and show these parts as you prefer.

Power BI Selection Pane Continue reading “Selection Pane Features In Power BI”

Bookmarks Pane Feature In Power BI

In this article, I will explore the

Bookmarks Pane Preview feature in Power BI

Bookmarking preview Feature in Power BI


What’s Bookmarks Pane Feature In Power BI?

Bookmarks Pane is a new preview feature that announced in Power BI October 2017 update.

  • It’s a powerful way to save and share out your insights.
  • It lets you save interesting states as part of your report.
  • It works as a report navigation for your report.
  • It helps you to organize and make presentations of your report.

How to use Bookmarks Pane in Power BI?

By default, the Bookmarks Pane is not available because of it’s still a preview feature.

Bookmarking (preview) In Power BI

Enable Preview features in Power BI

To enable any Preview features in Power BI, you should do the following: Continue reading “Bookmarks Pane Feature In Power BI”

Power BI: Calculate The Project Status In Project Server

In this article, I will explain

How to Calculate The Project Status In Project Server based on the Project Start and Finish Date In Power BI?

Power BI: Calculate The Project Status In Project Server Continue reading “Power BI: Calculate The Project Status In Project Server”