Forum Discussion
Columns Not Showing in Table Format
Hello,
I am a new user of Power BI desktop. I've created a simple table with limited columns and noticed that when I am adding the Architect's name as a column, the table is only displaying records with an Architect associated to it. I've doublechecked the mapping and relationships but cannot figure out the issue. Do you have a solution you can recommend? Your help is greatly appreciated. Thank you!
Hi debkops0810
Did you create a measure to get Architect result? Measure will show aggregate result.
Here I suggest you to use "Show items with no data" Function in your [Educational Projects] column in Value Field in your table visual.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
debkops0810 , Not very clear.
If you have dimension (one side of the table) and you have fact(many sides) have measure. Then you will only get a record from Dimension, which has value in fact.
You can add +0 to the measure to get all values
Thank you but I'm not quite understanding. My table shows 5 educational projects we've completed; 3 of which has an Architect listed. When I'm adding the column for the Architect's name on the table, only 3 records are displayed, not 5. Would this be resolved via by modifying the measure?
Hi debkops0810
Did you create a measure to get Architect result? Measure will show aggregate result.
Here I suggest you to use "Show items with no data" Function in your [Educational Projects] column in Value Field in your table visual.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
