Forum Discussion

dethnass's avatar
dethnass
Icon for Helper I rankHelper I
6 years ago

too many measures

Hi Everyone,

 

I want to visualize all my ticker on single chart

 

My Dataset Like:

 

Every each column needs a 5x measure to being part of chart

 

My Measures are:

1st : RawMSFT = SUM('Table1'[Close_6])

2nd: MSFT = IF(CONTAINS('SlicerTable','SlicerTable'[slicernames],"MSFT"),[RawMSFT],BLANK())

3rd: FirstValueMSFT = Calculate(Values(Table1[Close_6]), Sample(1,'Table1','Table1'[Date],ASC))

4th: LastValueMSFT = Calculate(Values(Table1[Close_6]), SAMPLE(1,'Table1',Table1[Date],DESC))

5th: MSFTpct = CALCULATE((Query1[LastValueMSFT]-Query1[FirstValueMSFT])/Query1[FirstValueMSFT])

 

At the first sight; it seems ok to add all those measures but i have an 400+ column like to be ready to using in chart. It means 400 X 5 = 2000 measures.

 

Is there any way to achieve this in Power BI?

 

Example file here: https://www.dropbox.com/s/0spx4mg9mugg1o8/ticker.pbix?dl=0 

1 Reply

  • FrankAT's avatar
    FrankAT
    Icon for Community Champion rankCommunity Champion

    Hi dethnass ,

    get the new PBID update, download and install the Tabular Editor. You'll get the new tab External Tools if you set File > Options and settings > Options > Preview Features and activate the marked checkbox (see figure). Inside Tabular Editor you can create calculated groups. I think this may help.

     

     


    Regards FrankAT