Forum Discussion

swinings's avatar
swinings
Icon for Helper I rankHelper I
5 years ago
Solved

Power BI add data to a specific row in visual

Alright. I'm back. This project is frustrating. It is completely possible in Excel, but I am struggling in Power BI   Goal:  To add a value to a specific row in a table visual or column visual.  ...
Need Help
  • aj1973's avatar
    aj1973
    5 years ago

    Hi swinings 

    You want to see it like this?

    or like this 

    if so then you need to connect the 2 tables

     

aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
5 years ago

Hi swinings 

You want to see it like this?

or like this 

if so then you need to connect the 2 tables

 

swinings's avatar
swinings
Icon for Helper I rankHelper I
5 years ago

I'm leaning towards the 2nd but with all other values at $0 while CD would be $81. That way, the user can see what has been affected and what hasn't all next to each other.

  • swinings's avatar
    swinings
    Icon for Helper I rankHelper I
    5 years ago

    For instance, in excel, I can create a formula to add the amount in that specific category if it says career discovery. I can't in PBI, or just don't know how.