Forum Discussion

ChihiroWa's avatar
ChihiroWa
Frequent Visitor
1 year ago
Solved

sparkline in matrix

Hello. I hope someone can help me with my problem.   This is a matrix of population data by country sourced from Worldbank. Since 2023 is selected in the slicer for selecting the year, the numbers...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi ChihiroWa ,

     

    Okay, I reproduced your situation.

     

    To solve this problem, simply use “Year” as the X-axis under the date hierarchy of the “Calendar” table instead of “Population_total”. (Note: Do not select the date and do not select the created calculated column Year as the X-axis)

     

    The final page visualization is shown below:

     

    The pbix file is attached.

     

    If you have any other questions please feel free to contact me.

     

    Best Regards,
    Yang
    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!

bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
1 year ago

ChihiroWa Try creating a measure using this

 

DAX
UnfilteredPopulation =
CALCULATE(
SUM('Population_total'[Population]),
ALL('Population_total'[Date])
)

ChihiroWa's avatar
ChihiroWa
Frequent Visitor
1 year ago

Thanks for the reply. Unfortunately nothing has changed. Is this the correct sparkline setting?

合計：sum total