Help with Power BI Metrics

[LearningHub_KD]

Only Growth % should be shown in year where prvs year is available in this case 2023 wouldn't have any comparisons,

similarly for forecast which will only be shown in future years 2025, 2026 not in 2023 and 2024 which current and prvs year

How can I achived this in Power BI metrcis ?

Data and and Desired results are in SS

[Anonymous]

Hi @LearningHub_KD ,

Try turning off text wrapping and auto-size width, and then manually drag and drop the width of the column to hide the unwanted columns:

Here's an example file.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum 

[LearningHub_KD]

Hi , I have tried it . It only solves visuals once I export it every columns comes to excel 

[Anonymous]

Hi @LearningHub_KD ,

Yes, there is currently no way to select columns during data export, please consider submitting this idea.
Welcome to Microsoft Fabric Ideas

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum 

[LearningHub_KD]

City	Year	Operating Expense	Actual Sales	Plan Sales
A	2023	259	702	609
A	2024	288	735	604
A	2025	233	587	607
A	2026	212	688	597
A	2023	201	645	729
A	2024	224	711	652
A	2025	319	594	652
A	2026	285	679	631
A	2023	256	664	550
A	2024	286	592	589
A	2025	208	597	570
A	2026	330	595	563
A	2023	269	643	716
A	2024	200	659	614
A	2025	281	736	574
A	2026	235	576	704
B	2023	224	626	691
B	2024	224	636	741
B	2025	267	717	625
B	2026	326	699	636
B	2023	260	733	680
B	2024	280	661	743
B	2025	201	669	555
B	2026	292	721	554
B	2023	221	562	611
B	2024	250	640	736
B	2025	293	660	630
B	2026	302	730	587
B	2023	221	555	565
B	2024	244	587	612
B	2025	322	641	693
B	2026	238	641	552

Hi ,

Will this work

[PijushRoy]

Hi @LearningHub_KD 

Please share sample PBIX file link or sample data in excel format