Power BI Modelling & DAX: Custom Sorting to Power BI Visuals with DAX DataTable Functions

 Power BI Modelling & DAX: Custom Sorting to Power BI Visuals with DAX DataTable Functions.





DAX Codes for generating the DIM table:


BP Indicator (Index by DAX) =

DataTable(

"Attribute", STRING, "Indicator", STRING, "Index", INTEGER,

               {  

                        {"Systolic BP","Systolic",1},  

                        {"Diastolic BP","Diastolic",2},  

                        {"Heartbeat","Pulse",3}

                }

               )

Comments

Popular posts from this blog

Power BI DAX Formula for Dynamic Ranking Calculations Based on User Selections and Filters

Power BI DAX and Visualizations: Active employees across time (as x-axis) by Tenure group or age group

Excel VBA Tips: A Macro to Generate Line Chart Dynamically for Loan Schedule Trend Report