Forum Discussion
Solved
Conditional columns
Hi, I have a requirement where in I have to show the trend of Revenue and other parameters in graph and table visual. I have below columns in my dataset Location, Invoice_Date, CustomerName, Pr...
apatwal , I added measures for quantity, check those, same way you can create for revenue
apatwal , Put Revenue , Margain [DAte].Year or create a year column and use that viusal.
Bot able to get the challenge here
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Please find the attached PBI sample file
https://drive.google.com/file/d/1eLI2gSvf84ul0RqB_8TX2QZUvgDSMtYh/view?usp=sharing
I need two different columns that shows Revenue for 2020 and 2021 separately and same for other columns.
I want below structure in PBI
There should not be any Date filter.
Thanks...
apatwal , I added measures for quantity, check those, same way you can create for revenue