Forum Discussion

AgencyPowerBi's avatar
AgencyPowerBi
Helper III
5 years ago
Solved

Making custom table for the visual

Hi,   I have a need for a visual that would show:   Full year 2018 Current year 2019 Current year 2020 YOY% 2019 YOY% 2020   Now, I made calculaton group with these calculations (FY, YTD, Y...
Need Help
  • v-cazheng-msft's avatar
    v-cazheng-msft
    5 years ago

    Hi, AgencyPowerBi 

    According to your description, I think you can try the two methods. Can you provide some sample data removing sensitive data if it doesn't work?

     

    Method 1

    Calculate the result of ‘Full Year 2018’, ‘YTD 2019’ ‘YTD 2020’ and ‘YOY%’ in original table, then use thee values to create a new table. Use the new table to create visual.

     

    Method 2

    Do calculation in original table, add filters to the dax formula and just do calculation for these specific years.

     

    Best Regards,

    Caiyun Zheng

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

AgencyPowerBi's avatar
AgencyPowerBi
Helper III
5 years ago

I need table like this. So I need hiding 2018 YTD, 2018 YOY, FY for 2019 and 2020, etc..

Im making bar chart, so I need as little as bars as possible.

 

I can do this in excel, by hiding pivot elements and making a set.

How do I do it here?