Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Create Table in Power BI Similar To an Excel Table

Hi Experts

 

I am trying to create a column based table in Power BI which is similar to an excel table i have. The table shows sales and spend by category.

See attached links with sample data.

 

I have in my FACT a column named chkfmt  which indicates whether a value is a % or £ in the table.

 

Excel link.

https://www.dropbox.com/s/tx7dsl0jw2o9sr4/Book1.xlsx?dl=0 

 

Power BI Link

https://www.dropbox.com/s/bvkgwzr6wqxcwqe/SampleData_2.pbix?dl=0

 

Need to report to filter based on the shown filters too.

 

This is my measure so far.

 

 

 

Need Help

1 Reply

  • v-alq-msft's avatar
    v-alq-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi, Anonymous 

     

    The links for both excel and pbix file are unavailable. Could you please share us some sample data and expected result for better unstanding? Do mask sensitive data before uploading. Thanks.

     

    Best Regards

    Allan