Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I have read simular Posts but cannot see a fix for my situation, I have a graph that is set up as shown;
(Its filtered by a time slider so i didnt need to add the date)
I really want to plot zero, as sometimes people will do work, when they are not budgeted to do so, but when i try to do this with the methods i can find here (e.g +0), the small multiples (the task e.g "bookkeeping"), the filter on the page AND visual breaks, and it will show me every task that is irrelivant (no actual time, no budget). so it looks cleaner without all the ugly line breaks,
I only want to see those with actual time but no budget appearing as 0, for tasks that actually have data or where needed (e.g where there is a gap in the people.
Because task vary monthly i cant simply exclude to try to fix the filter break, well i guess its not really a filter break, it just thinks i want to see all the 0 values using +0 workaround i think,
Any help would be appricated!
Solved! Go to Solution.
Hi, @SioShoo
Please try creating a separated dimension table 'New Table' for column 'Full Name' and create a single filter relationship between original field 'Table'[Full Name] and new field 'New Table'[Full name].
new Table = DISTINCT(Table[Full Name])
After replacing Table'[Full Name] with 'New Table'[Full name] in X-axis, you can retry +0 workaround.
Best Regards,
Community Support Team _ Eason
Hi, @SioShoo
Please try creating a separated dimension table 'New Table' for column 'Full Name' and create a single filter relationship between original field 'Table'[Full Name] and new field 'New Table'[Full name].
new Table = DISTINCT(Table[Full Name])
After replacing Table'[Full Name] with 'New Table'[Full name] in X-axis, you can retry +0 workaround.
Best Regards,
Community Support Team _ Eason
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. Avoid posting screenshots of your source data if possible.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523