Forum Discussion

thiamhuat2026's avatar
thiamhuat2026
Helper III
3 months ago
Solved

Power BI Questions

I need help in this two cases here:

First: I need to remove that dot '.'  after the name of the Town_Council selected. It seems I need to enter something and the minimum I can have is a dot, but I want nothing from it. I am using the Card to display the dynamic display of Town_Council.

Or is there any other better option?

 

Second, since I have already displayed the Town_Council selected above, I do not need to display those Town_Council text on the bottom of each bar chart, but just need its different Category.

 

Thanks.

 

  • MFelix's avatar
    MFelix
    3 months ago

    Hi thiamhuat2026 ,

     

    Since you are using the new card visual you can just turn off the label from the card settings and this will not show in the visualization:

     

     

6 Replies

  • Hello thiamhuat2026,

    Looks like the . is being used as the alternate result in your SELECTEDVALUE.

    You can just replace it with BLANK():

    Selected Town Council =
    
    SELECTEDVALUE('Table'[Town_Council], BLANK())

    I tested something similar before and the Card stayed empty instead of showing the dot.

    For the chart labels, remove Town_Council from the Axis and leave only CATEGORY.
    Since the Town Council is already shown at the top, you do not really need it repeated again below the bars.

  • Hello thiamhuat2026 

     

    try this

    Use BLANK() instead of "." in your SELECTEDVALUE measure
    Selected Town Council =
    SELECTEDVALUE('Table'[Town_Council], BLANK())

    This will keep the Card empty instead of showing a dot when nothing is selected.

    For the bar chart, remove Town_Council from the Axis and keep only Category, since the selected Town Council is already displayed at the top.

     


    If my response helped you, please consider clicking
    Accept as Solution and giving it a Like 👍 – it helps others in the community too.

    Thanks,

    Connect with me on:
    LinkedIn |
    Data With Pankaj - YouTube
    • thiamhuat2026's avatar
      thiamhuat2026
      Helper III

      what I am saying is that I want to remove the whole text of "Selected_TC".

      Yes, the other of "remove Town_Council from the Axis and keep only Category" works.

      • MFelix's avatar
        MFelix
        Super User

        Hi thiamhuat2026 ,

         

        Since you are using the new card visual you can just turn off the label from the card settings and this will not show in the visualization: