I'm trying to find a way to visualize or calculate a table that displays growth or percentage change positive or negative in power bi. Is there a quick way to display that on a visual? Using Excel it would be easy to cell reference for example but how would I demonstrate this on Power BI.
The data inputted raw from SQL Server is as follows in record:
Table: Sheet1 Col: MONTH(Whole Number),CustomerID(Whole Number),CustomerName(Text),Sales Rep (Text),Sales total (decimal),Month Name(text)
Month was original extracted from SQL Server as a datepart value. I was unable to display simply the month name in Power BI, so I created a new field with the month name and its corresponding number date part.
I want to display the following:
Filter: Sales Rep
Months total % difference MoM growth
Jan $
Feb $
Mar ...
... ...