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.

     

v-cazheng-msft's avatar
v-cazheng-msft
Community Support
5 years ago

Hi, AgencyPowerBi 

You can create a Calculated table with these data you want to display and create visual with this table.

 

 

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

Ok, I'll play around and see if it helps.

 

Tx