Forum Discussion

Kiran_Gundu's avatar
Kiran_Gundu
Frequent Visitor
8 years ago
Solved

Filtering concepts

HI,   I have data as   Project  cost           revenue p1          1000              2000 P2           2000             4000 P3           3000              6000 p4           4000            1...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi Kiran_Gundu,

     

    Please check out the demo in the attachment.

    1. Add two columns.

    Profit = [revenue] - [cost] 
    Profit Percentage = [Profit] / [revenue]

    2. Create a table visual and a slicer.

    Filtering_concepts

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Kiran_Gundu,

 

Did it help? Can you mark it as an answer?

 

Best Regards,

Dale