Hi,
I want to use dynamic labels in my dashboard to show users what they are looking at, depending on the type of filters they select.
I am currently able to do this by creating individual measures, but this is getting a bit messy and difficult to manage. I'd like to put these all into a single table from which I can select the label.
I have tried to create a table to hold the label names and measures, both by entering the values in a new table, and creating one through DAX. Using the DAX causes issues and error message when appending a string value at the end of the column selected. Below is the DAX and the error message received.
Label = DATATABLE("Label_ID",INTEGER, "Label_Name", STRING, "Label_DAX", STRING,
{
{1, "Sales type label", "SELECTEDVALUE('Sales Type'[Sales Type]) &" "&""& SELECTEDVALUE('Period Intelligence'[Period Calculation])" } ,
Unexpected Expression "&""& SELECTEDVALUE('Period Intelligence'[Period Calculation])" } ,
However, when I attempt to label the Chart title by the new label value I have created, it is greyed out.
Has anyone managed to create a table by using DAX or entering in a new table and got this to work successfully?
Thanks
