Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
So i have a table visual that sums up "this months sales" from one "database", and shows phonecalls from an other "database" via an mesure.
But if the particular day has no phonecalls, the mesure column with phone calls dosen have any data, and the whole table is empty.
How do i get the other columns to show data in a visual, even if one of the colums thas should show a mesure is empty?
ive tried "show ithems with no data" in a few ways, but that only works on data and not the mesure.
Solved! Go to Solution.
Thank you for your help.
I just managed to solve it with creating a new date table and dimension table and making new dependencies.
it works better when you do it right i guess 🙂
Hi @Cody99 ,
Is there any blank value in the field [Sales Executive ID1] and [Sales Executive ID2]? In order to provide you a suitable solution shortly, could you please provide more raw data in your table 'CALLS ISE MTD Email' (exclude sensitive data) with Text format, the Fields setting of your visual and your expected result with backend logic and special examples? By the way, please provide some sample data and relationship info if it involves multiple tables. It would be helpful to find out the solution. You can refer the following links to share the required info:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
Thanks ill try to do better:
I have three data sets:
Dependencys are a salesnumber and Dates.
If one of the data sets (in this case calls) dont have any data on a date that im lokking at for instance month or week. Every other column dosent show data.
I have the date in the filter like this, filtered on "this month":
Hi @Cody99 ,
It seems the visual involveds the data from multiple tables. Are the fields on the Filters pane from different tables? Could you you please provide some raw data in these datasets (exclude sensitive data) with Text format, the Fields setting of your visual and your expected result with backend logic and special examples? It would be helpful to find out the solution. You can refer the following links to share the required info:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
Thanks for trying to help me, i just dont know how to provide all the data, and or pbix files, its just to tedius to exclude sensitive data and what not. (ive looked at the links you provided)
So i realize it will be hard to help me then.
The data is from several data sets yes.
and filters are from several data sets as well.
Hi @Cody99 ,
Since there are multiple tables involved in your model, does any relationship created among these tables? What's the base field if there is the relationship between two tables?
In addition, could you please try to remove these filters from Filters pane one by one to see if that visual can display some data?
I suspect that the visual was not be able to display data due to filter conditions or relationships created between tables... Whether it is possible to make some fake data to create a sample pbix file and share it with me? The pbix file only can "explain" the tables, relationship and filtes, that's ok. Thank you.
Best Regards
Thank you for your help.
I just managed to solve it with creating a new date table and dimension table and making new dependencies.
it works better when you do it right i guess 🙂
I got a bit forward.
I added + 0 to that mesure that added up calls, and now i got that data to show as 0 in the table visual,
Like this:
I think i can have something to do with filters.
I have 3 date elements in the filters pane, all filtered on "this month."
One date filter for every "database" i get data from.
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |