Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

TEXTO

Olá, o Power BI não está permitindo que eu coloque dados do tipo texto em um simples cartão, ele só permite colocar DAX, eu tento arastar uma coluna do tipo texto para o cartão e simplesmente ele não permite, como posso resolver isso ?

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous

     

    Thank you very much rajendraongole1 for your prompt reply.

     

    To create dynamic headers that change based on the filters applied, you can use expression-based headers in Power BI. Here's a step to set it up:

     

    Create a measure. Write a DAX formula that returns the required text according to the slicer. Such as

     

    Measure = "Title: " & SELECTEDVALUE('Table'[Title])

     

     

    Select card viusal. Go to the Visualizations panel and expand the General section.


    Activate the Title option. Next to the title text field, click the Conditional Format (fx) icon.


    In the dialog box that appears, select the title Dynamic measure you created and click OK.

     

     

     

    You can view the link below for more details:

     

    Expression-based titles in Power BI Desktop - Power BI | Microsoft Learn

     

    Regards, 

    Nono Chen 

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

3 Replies

  • Hi Anonymous - Next time, can you please convert to english and share it for better visibility. 

    As per my understanding using translator ,cards are typically used to display numerical values or aggregated data. However, if you want to display a single text value on a card you can create a measure as below and it works as follows

     

     

     

    Hope it helps.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks for replying @rajendraongole1 , actually what I need is to put a conditional formatting on a title, but there is also not allowing to put text, I have a filter on my page, and I want the title of a graphic to change according to the filter, and for that I need to put a conditional formatting of type text, But Power BI isn't allowing it.
      In another project, I can do this easily, it seems to be some configuration that is applied, I have looked for everything but I did not find out what it is about.

       

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous

     

    Thank you very much rajendraongole1 for your prompt reply.

     

    To create dynamic headers that change based on the filters applied, you can use expression-based headers in Power BI. Here's a step to set it up:

     

    Create a measure. Write a DAX formula that returns the required text according to the slicer. Such as

     

    Measure = "Title: " & SELECTEDVALUE('Table'[Title])

     

     

    Select card viusal. Go to the Visualizations panel and expand the General section.


    Activate the Title option. Next to the title text field, click the Conditional Format (fx) icon.


    In the dialog box that appears, select the title Dynamic measure you created and click OK.

     

     

     

    You can view the link below for more details:

     

    Expression-based titles in Power BI Desktop - Power BI | Microsoft Learn

     

    Regards, 

    Nono Chen 

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