Forum Discussion
Inerst Excel sheet to power bi exactly the same
Hello,
Im trying to build a report in power bi. and i have this attached snapshot, i have this table in excel sheet, and i want to move it exacly the same to power bi. same color same everyting, and yes i had to rename every cell like this
i looked for everything in power bi to build a table like this and i tried Addons from the store but nothing helped me.
for the black clomun i want to add a card that shows data that refresh dailty which is easy to do it. all i need to build the rest as the same shown, the only solution that i came up with to create text box and build it one by one which is gonna cost time from me as i need to buil 6 more reports.
thanks
HI Albara3113,
You can use these category fields on matrix row fields and create a new table with all measure names and use this new table field on matrix column fields.
Then you can write a measure formula to check the current row and column value and use them as condition to look up and summary table records.
Reards,
Xiaoxin Sheng
1 Reply
HI Albara3113,
You can use these category fields on matrix row fields and create a new table with all measure names and use this new table field on matrix column fields.
Then you can write a measure formula to check the current row and column value and use them as condition to look up and summary table records.
Reards,
Xiaoxin Sheng