I want to grop the blanks value to another bar. Is it possible?
For example, I want that blanks will be counted with code 9. So blank will be removed from the chart and 9 will show 292 + 5 = 297.
Solved! Go to Solution.
Hi @AClerk ,
By my tests, the solution of parry2k should be helpful.
I have made a test pbix to reproduce your scenario.
In addition, you could have a reference of the attachment.
That is more or less what I have done, but it is not working.
Thia is my DAX:
IF(Table[CODE] = "1", "1",
IF(Table[CODE] = "2", "2",
IF(Table[CODE] = "3", "3",
IF(Table[CODE] = "4", "4",
IF(Table[CODE] = "9" , "9",
Hey @parry2k ,
I am trying to map the codes to readable values. Sorry, I cannot write the real values due to sensetive data.
I am using numbers here just to ilustrate.
So, if code is 1, show text_1,
if code is 2, show text_2
if code is 9 or blank, show text_9
So the users can read the values and not guess what is the meaning of each code.
@AClerk interesting, you can use switch statement, easy to work with
Switch ( Table[Code] , 1, "Whatever text", 2, "Whatever text", 9, "text for 9", "text for 9" --this will be final condition if nothing matches above and blank will fall here
Although switch and if are the same, from logical perspective, I tried to use switch.
I am still with the same results.
New Code =
For some reason Power BI is not catching these blanks. Not sure why though.
@AClerk can you share visual like before using with new code on x axis
if possible, please share pbix, remove any sensitive information, we are surely missing something here.
I tried to export to csv the data, but clearly it works there and the visual shows correctly.
My original dataset is a Firebird DB.
Not sure how to share the PBIX without revealing the data.