Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

graph display error

Saeed A

i have a line graph which needs to display past 2 months data and current month data

i have the formula as well but it is not showing any graph

greeshma_0-1601143227877.pnghttps://drive.google.com/file/d/1lTcK5CQsdl3rteKc5GLimkEmjcjPDGR7/view?usp=sharing

image.png

  • nandic's avatar
    nandic
    5 years ago

    @greeshma ,

    The first step is to click on the "View details" link, says there is an error in comparing dax: you are trying to compare integer and text.
    The selected slicer gets the month name and tries to compare it to the month number.

    20200926 months.PNG

2 Replies

  • mwegener's avatar
    mwegener
    Most Valuable Professional

    Hi Anonymous ,

     

    the DAX error is that [Selected Slicer] returns the MonthName and not the Month (No.)

     

     

    • nandic's avatar
      nandic
      Resident Rockstar

      @greeshma ,

      The first step is to click on the "View details" link, says there is an error in comparing dax: you are trying to compare integer and text.
      The selected slicer gets the month name and tries to compare it to the month number.

      20200926 months.PNG