cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
siddharthj
Regular Visitor

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

 

1 ACCEPTED SOLUTION
amitchandak
Super User IV
Super User IV

@siddharthj , 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.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

6 REPLIES 6
siddharthj
Regular Visitor

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

Anonymous
Not applicable

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
v-yuta-msft
Community Support
Community Support

@siddharthj ,

 

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

 

Regards,

Jimmy Tao

amitchandak
Super User IV
Super User IV

@siddharthj , 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.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

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

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors