Forum Discussion

Nurzh's avatar
Nurzh
Frequent Visitor
3 years ago

Line and Clustered Column Chart, custom lines shared

Hi all,  I am trying to create Line and Clustered Column Chart, with custom lines Shortcut of dataset is below:   Is_reviewed Doc_number Forecast Dates Period Type True 61-BDIN-52001 Ju...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Nurzh,

I'd like to suggest you add a new table with these full categories to use on legend field. Then you can write Dax formulas to look up and aggregate raw table records based on current date axis and legend category. 

If these also not help, you can also consider using script-based visuals(R, Python) to manually plot the graphs that you wanted.

Regards,

Xiaoxin Sheng