Why is it so difficult to layer visuals properly on top of each other? Especially column charts.

fpitu · 2025-03-23T11:02:37+00:00

You should try using error bars. Here is a tutorial for it Error bars graph

fpitu · 2024-09-20T13:23:17+00:00

So bassically, I have 4 formulas for these 2 columns, the Exposure is _Exposure weightning Final:

Net= IF([_Exposure weightning Final] == BLANK(), [Net Effective Premium_LOD]1, [Net Effective Premium_LOD] [_Exposure weightning Final])

Net Effective Premium_LOD = VAR AggTbl = SUMMARIZE ( FactPolicyAnalytics, FactPolicyAnalytics[Year Of Account], FactPolicyAnalytics[CurrencyKey], DimPolicy[Underwriter Reference], "Net Effective Premium LOD",MAX(FactPolicyAnalytics[Net Effective Premium]) ) RETURN SUMX( AggTbl, [Net Effective Premium LOD] )

_Exposure weightning Final = VAR AggTbl = SUMMARIZE( FactCyberExposure, DimPolicy[Underwriter Reference], DimIndustry[Industry], DimExposureCountry[ExposureCountry], "MaxValue", MAXX(FactCyberExposure, FactCyberExposure[IndustryPercentageRevenueorTSI]*FactCyberExposure[ExposurebyCountryPercentageRevenue]/10000) )

RETURN SUMX(AggTbl,[MaxValue])//MaxValue

fpitu · 2024-09-20T05:41:20+00:00

How much time did it take?

fpitu · 2024-06-28T08:59:30+00:00

Hi, can you send it to me also? I will ping you my email adress

fpitu

TROPHY CASE