The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
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 |
---|---|
51 | |
42 | |
24 | |
23 | |
22 |