Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

visualising data in reports

Hi

I'm new to power BI and making an dashboard for review.

I have created lookup or dimension table, when displaying data in matrix view, all the values in lookup table are listed even when there is no corresponding data for those lookup values.

When using 'Filters' to eliminate the rows with '0' or 'is not blank' results in wrong totals. Tried variation with 'distinct' / 'distinctcount' without success.

Appreciate advice.

Thanks,

Siddharth

 

Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , have you created correct join with your dimension. It should me1 to many. Dimension to fact

     

    If even after correct join, it does not display the data, Can you share sample data and sample output.

6 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous , have you created correct join with your dimension. It should me1 to many. Dimension to fact

     

    If even after correct join, it does not display the data, Can you share sample data and sample output.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi amitchandak ,

      Thanks for your answer. All my relationships from Dimension tables to Fact Tables have cardinality 1 to Many.

      Please let me know how can I share sample data for Power BI Desktop.

      Thanks,

      Siddharth

      • amitchandak's avatar
        amitchandak
        Super User
        6 years ago

        You can put your file on one drive or dropbox and share the link.

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    6 years ago

    Anonymous ,

     

    Could you please share sample data and clarify more details about this issue?

     

    Regards,

    Jimmy Tao

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    To resolve, we need to have a sample that will highlight the issue. Otherwise it's not possible to tell you how to handle this.

    Best
    D
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi amitchandak , Anonymous , v-yuta-msft ,

    Thanks for your responses. I just wnated to update you all;

    when i created sample data for you all and re-run the report the problem got fixed and the matrix view is as it shuold be.

    as amitchandak suggested there were some issues with relationship between Fact & Dimension tables which got fixed on re-loading Fact data tables.

    So I went back and uploaded the Fact Data once again and Woaa... the reports were perfectly OK and good to move to next step...

    ...and next problem I am now posting...

    Thanks 

    Siddharth