Forum Discussion

lucamilanesi's avatar
lucamilanesi
Frequent Visitor
6 years ago
Solved

Using a text measure as a legend

Hello everyone,

 

I'd need your help: I created the measure "Measure_Level_Asset".

 

 Misura_Livello_Asset = IF(GOV_Asset[Misura_Rischio_Residuo_Asset]<1,"Azzurro",IF(GOV_Asset[Misura_Rischio_Residuo_Asset]<2,"Verde",IF(GOV_Asset[Misura_Rischio_Residuo_Asset]<3,"Giallo",IF(GOV_Asset[Misura_Rischio_Residuo_Asset]<5,"Arancione","Rosso"))))

 

the format is text type.

Unfortunately PBI does not allow me to use this measure in the legend fields of the various viewers (instograms for example).
I tried to convert the measurement into a calculated column but I make mistakes, in fact I display the error:

 

 

How can I reach a solution?

Thank you

Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    Hi lucamilanesi

     

    You cannot create calculated column based on measures.This process may be a little complicated, but it can solve your problem.
    1. Create a table with "Azzurro", "Verde", "arancione", "Rosso",Then you can use this column in the legend fields.
    2.Create four separately measures for “ Azzurro” and “ Verde” and “ Arancione” and “ Rosso”. Add these two measures into Values section of the chart.
    DAX is like this:

     

     

    num_Azzurro = COUNTROWS(
		FILTER(ALL('GOV_Asset'),
			[Misura_Livello_Asset] = "Azzurro"
		)
	      )

num_selection = 
    var _nv = SELECTEDVALUE('Table'[Column1])
    return SWITCH(_nv,"Azzurro",[num_Azzurro])

    You can refer to this .pbix.

     

     

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

5 Replies

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    6 years ago

    Hi lucamilanesi ,

     

    It is not possible to add a measure as chart legend, as measure actually returns a single value.

    Based on your description, you have a trouble with creating calculated columns. Can you provide some sample data and the results you want?

     

    Best Regards,

    Liang

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

    • lucamilanesi's avatar
      lucamilanesi
      Frequent Visitor
      6 years ago

      Thank you for your interest V-lianl-msft 

      This table is formed by the measure "Measure_Level_Asset", the content is the one in evidence (names of colors). Each asset is identified by a color (which may vary depending on the value assigned to the various parameters). In fact, this measure is dependent on another measure.
      I hope I have provided useful information.

      • V-lianl-msft's avatar
        V-lianl-msft
        Community Support
        6 years ago

        Hi lucamilanesi

         

        You cannot create calculated column based on measures.This process may be a little complicated, but it can solve your problem.
        1. Create a table with "Azzurro", "Verde", "arancione", "Rosso",Then you can use this column in the legend fields.
        2.Create four separately measures for “ Azzurro” and “ Verde” and “ Arancione” and “ Rosso”. Add these two measures into Values section of the chart.
        DAX is like this:

         

         

        num_Azzurro = COUNTROWS(
		FILTER(ALL('GOV_Asset'),
			[Misura_Livello_Asset] = "Azzurro"
		)
	      )

num_selection = 
    var _nv = SELECTEDVALUE('Table'[Column1])
    return SWITCH(_nv,"Azzurro",[num_Azzurro])

        You can refer to this .pbix.

         

         

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