Forum Discussion

Raghda_Alshehhi's avatar
Raghda_Alshehhi
Frequent Visitor
3 years ago

Compare same month with last year's month

Hi, Can anyone please, help me with my visualization? some of my coullegues have said that its confusing to understand the graph percentage change? i don't know where to apply the conditional format...
DAX
lbendlin's avatar
lbendlin
Super User
3 years ago

Here is an example 

 

If you like more help please provide sample data.

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    Here would be an example of the conditional formatting with icons

    Adjust as needed. see attached.

     

    • Raghda_Alshehhi's avatar
      Raghda_Alshehhi
      Frequent Visitor
      3 years ago

      Thank you very much for your response!!

      much appreciated. 
      may I ask one last thing, will the up/down arrow will show if i converted this to bar or visual graph ?

      • lbendlin's avatar
        lbendlin
        Super User
        3 years ago

        The availability of icons for conditional formatting varies between visuals.  It may not be available for the standard Column chart (bar chars are horizontal) but there might be custom visuals that allow that.

         

        Instead of the icons you can also use column color ( for example)  for the visual indication of the trend.