Forum Discussion
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
- AnonymousNot applicable
You can do this with Multi-row card visual.
set the values as follows:
- NickolajJessenSolution Sage
Well, your solution may vary, as you provided very little information. I'm making the assumption, that your jan, feb, mar values are summations and i'm making the assumption, that you have a calendar table.
Please refer to this post:
How to Get Your Question Answered Quickly - Microsoft Power BI Community
If this post solves your problem, accept it as a solution
Appreciate your kudos - PC2790Community Champion
Hey Shreeram04 ,
Try this:
MaxValueMonth = FIRSTNONBLANK(TOPN(1,VALUES(Table[MonthName]),[measuretogetthemaxvalue]),1) - isabellaMicrosoft 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.