Forum Discussion

Shreeram04's avatar
Shreeram04
Resolver III
4 years ago

Display Month Name

Hi All,

 

I want to display the month name on a card that has the largest value in the year. For example, January has a value of 20, Feb has 40 and march has 50 means I want to display march(Month name) on my data card.

 

Please help me figure out this one. Thanks in advance.

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    You can do this with Multi-row card visual.

     

    set the values as follows:

     

     

     

  • PC2790's avatar
    PC2790
    Community Champion

    Hey Shreeram04 ,

     

    Try this:

    MaxValueMonth = FIRSTNONBLANK(TOPN(1,VALUES(Table[MonthName]),[measuretogetthemaxvalue]),1)
  • isabella's avatar
    isabella
    Microsoft Employee

    Hi Shreeram04 

     

    I did a local test ,you can take a reference 

     

    Here is my test  table

     

     

     

     

    First I created a calendar table

     

    Then create a one-to-one relationship between these two tables

     

     

     

    Then create another table like this:

     

    month for maxsale = TOPN(1,VALUES('calendar table'[Date].[MonthNo]),CALCULATE(SUM('Table'[sales])))

     

     

     

    We can see that  month 6 has the max sales

     

    Best Regards,

    Community Support Team _Isabella

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.