swafi Tracker

How to rename the (Blank) which is part of the x-Axis title?

swafi — Wed, 20 Dec 2017 16:09:22 GMT

Hi all
I attached a picture that describes the problem that I have which is I want to rename the (Blank) word that show up in the picture to Projects not Assigned to Program .

this section that written underneath it (Blank) refers to the count of projects that are not assigned to any program, in other words refer to the count of the projects that has null value in the program_id attribute in the project table but these projects priotrized in the table and as the visual shows.

Re: How to Include the records that have NULL value in one of their fields at Power BI Table Visual?

swafi — Wed, 20 Dec 2017 16:23:05 GMT

Actually, I solved the problem but in different way.

I had click the drop down arrow next to the field that I dropped in values in tables visual and select "Don't Summarize".
It was defaulted to "Sum" instead of "Don't Summarize"

Thanks

How to Include the records that have NULL value in one of their fields at Power BI Table Visual?

swafi — Wed, 20 Dec 2017 23:19:53 GMT

I had an issue where I imported a SQL server dataset to Power BI Desktop, and I tried to make a Table visual out of three different fields from a table that my dataset has.
Also, my dataset table has some records with a NULL value but when I look at the Power BI visual table that I generated I see that those records deleted automaticaly!
So, how could I stop Power BI from doing that and let it include all the records that my dataset table have and let power BI view it exactly like how it appears in SQL server.
I attached a pic shows the missing records from Power BI table visual versus SQL server dataset table.

Couldn't create a dashboard from imported Power BI desktop file

swafi — Fri, 12 Jan 2018 19:01:27 GMT

I worked on imported MS-Sql dataset using Power BI desktop, and I done all the visualizations and created three different reports.
My next step was to create a dashboard out of these three reports so I had to switch to work on Power BI service; and when I imported the Power BI desktop file that I made to Power BI service and I started to try pin some visuals to a dashboard, the following error message poped-up:

(sorry , can't pin this visualization yet. please try again later.

We're working on this feature. please send us any other feedback about power BI.)

How to fix that and create my dashboard peacefully?