Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hello Everyone,
Problem: Not able to display "Show items with no Data" after changing the format of Month Name from "January" to "Jan".
Also, I tried creating a simple calculated column for changing the format of the Month. But still not able to get Blank Months.
I hope, You have understood my problem.
FYI ,
I need blank months but with MonthName in Short Form. Like above.
Solved! Go to Solution.
I resolved it by taking a separate Date Table and linking it with the Date column of the Table and then taking the Month from the Date table in the chart.
I resolved it by taking a separate Date Table and linking it with the Date column of the Table and then taking the Month from the Date table in the chart.
User | Count |
---|---|
85 | |
80 | |
77 | |
49 | |
41 |
User | Count |
---|---|
114 | |
56 | |
51 | |
42 | |
42 |