Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi!
I have a measure of Percent of Total and works fine, but when I put that measure in a Line Chart dosent show me the correct values. I mean in 2015 the percent of some region's GDP in the total country's GDP was 25% and in the 2014 was 23% and 2013 was 21% and so on. I want these values in a Line Chart.
How can I do that?
Here is my pbix file if it will be necesary https://1drv.ms/u/s!AtTnrgPUQzQCgyIOQaCQ4q9M5tZW
Thanks for read me!
Solved! Go to Solution.
Hi, change your measure to this:
Aporte al Crecimiento Anual = IF ( OR ( [Variacion PIB Anual] = 0; ( CALCULATE ( [Variacion PIB Anual]; ALLSELECTED () ) ) = 0 ); 0; DIVIDE ( [Variacion PIB Anual]; CALCULATE ( [Variacion PIB Anual]; ALLEXCEPT ( Tiempo; Tiempo[Año] ); ALL ( 'Geográfico' ) ); 0 ) )
Hi, change your measure to this:
Aporte al Crecimiento Anual = IF ( OR ( [Variacion PIB Anual] = 0; ( CALCULATE ( [Variacion PIB Anual]; ALLSELECTED () ) ) = 0 ); 0; DIVIDE ( [Variacion PIB Anual]; CALCULATE ( [Variacion PIB Anual]; ALLEXCEPT ( Tiempo; Tiempo[Año] ); ALL ( 'Geográfico' ) ); 0 ) )