Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
i have my AXIS = [created_month]
my bars are num / den (calculated by count of current month back 1 year)
my data has 20% nulls for [created_month]
my chart works ok except there is an extra row of data of blanks as shown in my image
i would like to add a measure or column [Month Year] of [created_month] and filter it to exclude blanks for my AXIS
OR
have to AXIS somehow not show the blanks
i need blanks in my data num and den calucations
Hi @Anonymous ,
Have you solved the problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please share some data sample and your desired output so that we could help further on it.
Best Regards,
Cherry
Hello @Anonymous I think I understand your need but perhaps not so forgive me if this does not answer your question fully.
I have found the most effective way to remove these is simply to filter them out either on the visual or the page. In your example I would do this on the Numerator column, on the visual level filter expand where it has Nuumerator and filter by IS NOT BLANK.
I hope this has helped
Kind regards
SingSing
Apply a visual level filter on any of value measure - is not blank
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |