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 to true.
.
The problem I am having is since I am importing my data via a mariadb connection, I can't access the table tab.

Does anybody know how to change segment names without having access to table tab?

If you need more information let me know.

Thank you in advance!
Regards,
David

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")

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    Anonymous , You have to create a new column for that

     

    New segment =

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

  • Ritaf1983's avatar
    Ritaf1983
    Super 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