Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi power bi community
I am new to power bi and i have a problem regarding of modelling
below image you can see the data is in without filtering .But when i apply filter data does not showing
And i am trying to create relationship between the tables and applying bi direction also , but nothing is happening and nothing is showing in 2nd img you can find this . if any one knows about this and what mistake that i have been done here please help me on this as soon as you know
Thanks in adavnce
@rammy , In a visual take status_code and Invoice_amount togther. Do you see value for WIN?
If you do not see value for WIN, But see data for others, it means not data for WIN or there is issue with join (Lowercase/upper case) in case of text column join
if you see data with blank status, it means there is some problem with the values on the join column
Hi @amitchandak
yeah u said right .but i am crosschecking the data columns has been already matched as 1:* ,i have checked why it shows 1:* while the values are already having nulls .after checking one column have very rare numeric values and alsomore null rows thats why it shows as 1:* .but here i did not get any required output because nulls contains both table .please suggest me , without common columns are not available in both tables to create relationship.how do i explicitly create columns to create relationships in boyh tables
NOTE : DATA FETCHING FROM SQL AND NOT ONE COLUMN IS MATCHED IN BOTH TABLES
relationship for your reference
THIS IS ONE TABLE COLUMN
THIS IS ANOITHER TABLE
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |