Forum Discussion
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
Community 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