How to access Null months with Parameter ?
💥My Website💥
► https://dancesingwithdata.com/
In this video you will learn how to display and query null months with Parameter ?
A parameter is a workbook variable such as a number, date, or string that can replace a constant value in a calculation, filter, or reference line.
For example, you may create a calculated field that returns True if Sales is greater than $500,000 and otherwise returns False. You can replace the constant value of “500000” in the formula with a parameter. Then, using the parameter control, you can dynamically change the threshold in your calculation.
You can even create a dynamic parameter that’s set to automatically refresh its current value (to the result of a single-value, view-independent calculation), list of values (based on a data source column), or range of values. This will happen each time the workbook is opened and Tableau connects to the data source referenced by the parameter, or whenever you select Refresh from the data source’s context menu..
You can make your parameters more dynamic and interactive by using them in Parameter Actions. Parameter actions let your audience change a parameter value through direct interaction with a viz, such as clicking or selecting a mark.
🗣 CONNECT WITH ME ON SOCIAL
💥How to rank with Power BI 💥
► https://dancesingwithdata.com/tableau...
💥KB Article 💥
► https://kb.tableau.com/articles/howto...
💥Twitter 💥
► / riteshbisht01
💥Linkedin💥
► / ritesh-bi. .
💥Tableau Community 💥
►https://community.tableau.com/people/...
💥Workbook Optimizer 💥
►https://help.tableau.com/current/pro/...
Use RANK()
Rather than INDEX, you can use the following calculation:
RANK(SUM([Sales]))
This calculation has the sort order built in, so you can skip the Sort Order step above when using this method.