Forum Discussion
Making custom table for the visual
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.
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?
Hi, AgencyPowerBi
You can refer Basics of Time Intelligence in DAX for Power BI; Year to Date, Quarter to Date, Month to Date, Custom Year-Over-Year Calculation in DAX and DatesInPeriod vs DatesBetween; DAX Time Intelligence for Power BI.
Best Regards,
Caiyun Zheng
Hi,
thanks, but I can calculate the measures. That is not the problem.
My problem is making the table that I can visualise in the chart.
There are two ways: make the measures and put measures in the chart. That way I end up with three values for each year (FY, YTD and YOY%). I want to hide specific year measures from the chart.
Is there a visual that allows me to hide specific data (FY 2019, FY 2020, YTD 2018, for instance).
By making calculated table, Bar chart doesn't allow me to put calculated column into the chart.
So these two are my primary problems.
In excel, I would pivot the data, copy pivot, delete colums I dont need and make the visual. What is method for doing this in Power BI?
Than you!
