Forum Discussion
undefined
Hi mcantos - I have some key ideas, please check once.
Create a measure for each cell you need to populate (based on Stage and Status), which will avoid the need to create 9 or 6 separate datasets.
A matrix should work for cross-tabulation of Status and Stage. It dynamically expands and simplifies the table structure.
Focus on formatting and grid alignment to make the matrix look as close to a report as possible.
This approach should give you more flexibility than manually creating separate datasets for each table while keeping the report structure more maintainable.
Hope the above informaiton helps.
Hi mcantos - I have some key ideas, please check once.
Create a measure for each cell you need to populate (based on Stage and Status), which will avoid the need to create 9 or 6 separate datasets.
A matrix should work for cross-tabulation of Status and Stage. It dynamically expands and simplifies the table structure.
Focus on formatting and grid alignment to make the matrix look as close to a report as possible.
This approach should give you more flexibility than manually creating separate datasets for each table while keeping the report structure more maintainable.
Hope the above informaiton helps.
Hi rajendraongole1 ,
Sorry for the delay. The idea about using measures worked 🙂 so, thank you so much.
I have a quick question
Is there a way to remove the blank cells? I want each cell to start from the top. Is it possible?
Thank you!
Hi mcantos -Yes,You can filter out blank rows or columns using Power BI’s filter functionality,Select your visual, and in the Visualizations pane, locate the field in either the Rows or Columns well.Click the dropdown arrow next to the field and apply a filter:Exclude Blanks by unchecking the "(Blank)" option.
another way is you can create measure with if statement.
Hope this information helps.