The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi community,
I have created a column chart for 7 sequencial stages in the sales process and the associated value for each stage. Currently the column chart resizes and doesnt show certain stages which has no value in it when i apply filter based on sales person.
I would like the x axis to remain the same without turncating stages which are blank
Can anyone suggest a solution pls?
Regards,
Hareesh
Solved! Go to Solution.
Hi @HareeshRPV
Create a new measure with the following below, what this will do is when it is blank it will return a zero
My New Measure = IF(ISBLANK([Current Measure]),0,[Current Measure])
Thanks a Lot !
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
36 | |
28 | |
23 | |
13 |