Forum Discussion
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, YOY%)
I need to make a chart in which I would leave only specific colums as above.
This can be done in excel through set definition on a pivot.
Can something similar be done in Power BI desktop?
Thanks!
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.
8 Replies
AgencyPowerBi , At the end of this video. A measure slicer is been used. Check if that can help
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?
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.
Ok, I'll play around and see if it helps.
Tx
Can you please help?! can you give me an example with Time Intelligence columns?
