not sure if the title is accurate way to ask my question...
building a power bi report - and in the data set i have 2 columns i want to work with:
Column 1 - Type (3 categories - plastic, metal, misc.)
Column 2 - $
in my charts - I seem to run into an issue where I cannot get 3 graphs to show a trend as it thinks the column 1 is only 1
So i want to split it up in power query - make a custom column (column 3) with a function that shows IF Column 1 = Plastic, then Column 2 value and so forth.
Could I get your assistance for this?
building a power bi report - and in the data set i have 2 columns i want to work with:
Column 1 - Type (3 categories - plastic, metal, misc.)
Column 2 - $
in my charts - I seem to run into an issue where I cannot get 3 graphs to show a trend as it thinks the column 1 is only 1
So i want to split it up in power query - make a custom column (column 3) with a function that shows IF Column 1 = Plastic, then Column 2 value and so forth.
Could I get your assistance for this?