Forum Discussion

southpawmurph's avatar
southpawmurph
New Member
5 years ago
Solved

Legend for Multiple Columns

I am experiencing an issue that I need a legend that can be used for the 12 "OPEX" fields/columns seen in the screenshots. The issue is that I have a column "OpexSpend1_Label" which has the labels bu...
Need Help
  • v-cazheng-msft's avatar
    v-cazheng-msft
    5 years ago

    Hi, southpawmurph 

    You can create a Calculated table and use it to create visual. Here is the pbix.

     

    Best Regards,

    Caiyun Zheng

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi southpawmurph 

For these type of scenario

use "OpexSpend1_Label" in the axis box and then you will be able to add all  your columns in "Values" field.

Let the legend field be empty.

southpawmurph's avatar
southpawmurph
New Member
5 years ago

I have all my data fields as Count, I would like to see each OPEX group on the x-axis and the y-axis would be the count, the legend would then be the Labels. I want to be clear the label column "OpexSpend1_Label" was taken from the OpexSpend1 column by creating a conditional column (if OpexSpend1 = 1 OpexSpend1_Label =Cloudbased). I'm pretty new and my understanding of data relationships is poor.