In this article, I will show How to
Calculate the total rows, Ignoring Filters In Power BI
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”
In this article, I will show How to
Count Blank (NULL) values In Power BI Chart
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
Continue reading “Count Blank Values 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.
Continue reading “Selection Pane Features In Power BI”
In this article, I will explore the
Bookmarks Pane 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.
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”
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?
Continue reading “Power BI: Calculate The Project Status In Project Server”
In this article, I will show
How to query data from SharePoint List / Library in Power BI.
- Using OData Feed.
- Using SharePoint List Connection.
Get SharePoint List/Library Using OData Feed
Let us first briefly define what the OData?
The Open Data Protocol (OData) is a data access protocol for the web.
- OData provides a uniform way to query and manipulates datasets through CRUD operations (create, read, update, and delete).
- OData defines an abstract data model and a protocol that let the client access information exposed by SharePoint.
Continue reading “Power BI: Read data from SharePoint List”
In this article, we will show
How to display and sort a Slicer control by Month or Quarter Name in Power BI?
A slicer is a powerful alternative way to filter the dataset shown on the page.
In PowerBI, when you try to use the slicer to filter by a date field, it shows the year of this date field by default.
Continue reading “Show and Sort Slicer By Month or Quarter Name in Power BI”