too many measures

[dethnass]

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 

[FrankAT]

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