Forum Discussion

rammy's avatar
rammy
Helper I
4 years ago

After filter is applying data does not showing

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

 

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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

    • rammy's avatar
      rammy
      Helper I
      4 years ago

      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