Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Team,
I have two sample tables here named Cust and Invoice
the relationship in power bi desktop is many to many
Now i want to create a tabular view with Date, Custid, Cust name, invoice amount, here i want to filter the date as 15.1.2021, 16.01.2021 and 17.01.2021 and want to see the invoice amount
As you can see in above table that the custid of above dates are not available in Cust table. however i want to see the invoice amt with custid as blank
i am getting a blank tabular view.
when i select show items with no data i am getting this result
Invoice amt total is correct but i have no data for individual date,
is it possble anyhow to see invoice amt for individual dates when the data is not in first table ??
Solved! Go to Solution.
Hi @Anonymous ,
As per my understanding the only way to achieve this is through Merging.
Hi @Anonymous ,
The Invoice Amount cannot be shown as the corresponding customer ID are not available in the Customer Table. In your case for the three dates ie: 15th,16th and 17th January 2021 the customer IDs 16,17 and 18 are not available in the Customer Table. Since these are not available you can only show them as blank.
Please accept this as a solution if your question has been answered !!
Appreciate a Kudos 😀
Exactly i want to show them as blanks in the tabular view
the output i want is
is this possible to show in power bi??
Hi @Anonymous ,
You can merge the two tables as shown below and then expand the columns required from the merged table:
Use this merged table to create the table required.
Please accept this as a solution if your question has been answered !!
Appreciate a Kudos 😀
Thanks Jaideep
seems like merging is the only way, is not it ?
Hi @Anonymous ,
As per my understanding the only way to achieve this is through Merging.
Hi @Anonymous ,
Can you share a PBIX file with the sample data if possible ?
Hi Jaideep,
Here is the link to download the file.
https://www.dropbox.com/s/ecw0ogej10qvmr1/Samplefile.pbix?dl=0
Thanks
User | Count |
---|---|
124 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |