Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Change Segment Name

Hello everybody! I am having some slight problems while creating my report. I don't know how to change segment names in my pie chart. I want to rename the segment named 0 to false and the segment 1...
Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    Anonymous , You have to create a new column for that

     

    New segment =

    if([segment]=1, "True", "False")

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
2 years ago

Hi Anonymous 
You can create 2 measures for the pie slicers, like :

False = CALCULATE(COUNTROWS('Table'),'Table'[category]="0")
True = CALCULATE(COUNTROWS('Table'),'Table'[category]="1")
Results:

The formula can be any other that you need (like sum)
pbix is attached you can follow

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly